Click here to Skip to main content
15,904,416 members
Home / Discussions / Database
   

Database

 
GeneralRe: Error when passing multiple values Pin
Mycroft Holmes15-Aug-16 13:02
professionalMycroft Holmes15-Aug-16 13:02 
QuestionHow do Coders Get Database Experts? For a project Pin
TheOnlyRealTodd8-Aug-16 20:58
professionalTheOnlyRealTodd8-Aug-16 20:58 
AnswerRe: How do Coders Get Database Experts? For a project Pin
Mycroft Holmes9-Aug-16 13:04
professionalMycroft Holmes9-Aug-16 13:04 
AnswerRe: How do Coders Get Database Experts? For a project Pin
Nathan Minier10-Aug-16 1:21
professionalNathan Minier10-Aug-16 1:21 
AnswerRe: How do Coders Get Database Experts? For a project Pin
jschell12-Aug-16 11:15
jschell12-Aug-16 11:15 
QuestionHow to pass varchar as WHERE field IN param Pin
Jassim Rahma5-Aug-16 5:14
Jassim Rahma5-Aug-16 5:14 
AnswerRe: How to pass varchar as WHERE field IN param Pin
Mycroft Holmes5-Aug-16 13:04
professionalMycroft Holmes5-Aug-16 13:04 
AnswerRe: How to pass varchar as WHERE field IN param Pin
David Mujica9-Aug-16 6:20
David Mujica9-Aug-16 6: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 1:41
Member 1266244831-Jul-16 1:41 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen31-Jul-16 2:20
professionalEddy Vluggen31-Jul-16 2:20 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624481-Aug-16 2:04
Member 126624481-Aug-16 2:04 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen1-Aug-16 7:35
professionalEddy Vluggen1-Aug-16 7:35 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
User 1106097931-Jul-16 2:23
User 1106097931-Jul-16 2:23 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624481-Aug-16 2:01
Member 126624481-Aug-16 2:01 
QuestionRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
User 110609791-Aug-16 2:07
User 110609791-Aug-16 2:07 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 1:04
Member 126624485-Aug-16 1:04 
AnswerRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming1-Aug-16 2:21
mveRichard Deeming1-Aug-16 2:21 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Eddy Vluggen1-Aug-16 10:55
professionalEddy Vluggen1-Aug-16 10:55 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 1:21
Member 126624485-Aug-16 1:21 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming5-Aug-16 1:56
mveRichard Deeming5-Aug-16 1:56 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 1:20
Member 126624485-Aug-16 1:20 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming5-Aug-16 1:53
mveRichard Deeming5-Aug-16 1:53 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 9:14
Member 126624485-Aug-16 9:14 
QuestionSearching for the right database Pin
Kogs-7927-Jul-16 3:04
Kogs-7927-Jul-16 3:04 
SuggestionRe: Searching for the right database Pin
Richard MacCutchan27-Jul-16 4:56
mveRichard MacCutchan27-Jul-16 4: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.