Click here to Skip to main content
15,877,915 members
Home / Discussions / Database
   

Database

 
QuestionError when passing multiple values Pin
Jassim Rahma12-Aug-16 12:53
Jassim Rahma12-Aug-16 12:53 
AnswerRe: Error when passing multiple values Pin
Mycroft Holmes12-Aug-16 14:21
professionalMycroft Holmes12-Aug-16 14:21 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 5:32
Jassim Rahma13-Aug-16 5:32 
GeneralRe: Error when passing multiple values Pin
Richard MacCutchan13-Aug-16 6:03
mveRichard MacCutchan13-Aug-16 6:03 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 7:08
Jassim Rahma13-Aug-16 7:08 
GeneralRe: Error when passing multiple values Pin
Richard MacCutchan13-Aug-16 8:29
mveRichard MacCutchan13-Aug-16 8:29 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 11:12
Jassim Rahma13-Aug-16 11:12 
GeneralRe: Error when passing multiple values Pin
Victor Nijegorodov13-Aug-16 11:15
Victor Nijegorodov13-Aug-16 11:15 
Jassim Rahma wrote:
but when I run:
SQL
CALL sp_populate_memo_country_companies("BH", "US")

I get:
[SQL] CALL sp_populate_memo_country_companies("BH", "US")
 
[Err] 1318 - Incorrect number of arguments for PROCEDURE bluefile.sp_populate_memo_country_companies; expected 1, got 2

Just pack all the patterns for IN clause in one varchar/string value and pass this value as a single argument!
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 11:21
Jassim Rahma13-Aug-16 11:21 
GeneralRe: Error when passing multiple values Pin
Mycroft Holmes13-Aug-16 14:04
professionalMycroft Holmes13-Aug-16 14:04 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma15-Aug-16 8:16
Jassim Rahma15-Aug-16 8:16 
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 
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 

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.