Comments by mudassir 1988

mudassir 1988 23-Jul-10 6:34am View

Hi when i debug my code than i saw ,at line ,foreach (DataRow dr in ds.Tables[1].Rows).it cant come at data row and cant give exception ,and goto the line display poll and display the poll but without option what i do.

mudassir 1988 23-Jul-10 6:33am View

Yes u r right my query are disable to select 'Answer' .my query r as follows
delimiter$$

DROP PROCEDURE IF EXISTS `mysql`.`GetActivePoll` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetActivePoll`()
BEGIN
SELECT PK_PollId, Question
FROM pol_question
WHERE Active+0 = '1' ;

SELECT PK_OptionId, Answer, Votes FROM polloptions WHERE FK_PollId IN (SELECT PK_PollID FROM pol_question WHERE Active+0 = '1');

END $$

delimiter ;
I think the error accour due to Active how can i correct it
plz help me
Thanks -

mudassir 1988 23-Jul-10 6:33am View

Hi when i debug my code than i saw ,at line ,foreach (DataRow dr in ds.Tables[1].Rows).it cant come at data row and cant give exception ,and goto the line display poll and display the poll but without option what i do.
plz help me

mudassir 1988 23-Jul-10 6:31am View

Hi when i debug my code than i saw ,at line ,foreach (DataRow dr in ds.Tables[1].Rows).it cant come at data row and cant give exception ,and goto the line display poll and display the poll but without option what i do.
plz help me

mudassir 1988 22-Jul-10 2:22am View

Yes u r right my query are disable to select 'Answer' .my query r as follows
delimiter$$

DROP PROCEDURE IF EXISTS `mysql`.`GetActivePoll` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetActivePoll`()
BEGIN
SELECT PK_PollId, Question
FROM pol_question
WHERE Active+0 = '1' ;

SELECT PK_OptionId, Answer, Votes FROM polloptions WHERE FK_PollId IN (SELECT PK_PollID FROM pol_question WHERE Active+0 = '1');

END $$

delimiter ;
I think the error accour due to Active how can i correct it
plz help me

mudassir 1988 22-Jul-10 2:21am View

delimiter$$

DROP PROCEDURE IF EXISTS `mysql`.`GetActivePoll` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetActivePoll`()
BEGIN
SELECT PK_PollId, Question
FROM pol_question
WHERE Active+0 = '1' ;

SELECT PK_OptionId, Answer, Votes FROM polloptions WHERE FK_PollId IN (SELECT PK_PollID FROM pol_question WHERE Active+0 = '1');

END $$

delimiter ;
I think the error accour due to Active how can i correct it
plz help me

mudassir 1988 22-Jul-10 2:19am View

Yes u r right my query are disable to select 'Answer' .my query r as follows
delimiter$$

DROP PROCEDURE IF EXISTS `mysql`.`GetActivePoll` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetActivePoll`()
BEGIN
SELECT PK_PollId, Question
FROM pol_question
WHERE Active+0 = '1' ;

SELECT PK_OptionId, Answer, Votes FROM polloptions WHERE FK_PollId IN (SELECT PK_PollID FROM pol_question WHERE Active+0 = '1');

END $$

delimiter ;
I think the error accour due to Active how can i correct it
plz help me
Thanks

mudassir 1988 21-Jul-10 13:58pm View

it give resultset column Answer.what i do

Comments by mudassir 1988 (Top 8 by date)