Jump to content

Execution problem


sajithtgs

Recommended Posts

Hello,

 

Menu Name is show as (Excluded)

 

select Menu_id, case when Menu_Type='S' and ParentMenu_Id=0 then  Menu_Text

  when Menu_Type='S' and ParentMenu_Id!=0 then

INSERT(Menu_Text,1, 0, Space(length(Menu_Heirarchy ) ))

  Else  INSERT(Menu_Text,1, 0, Space(12)) End as MenuName

  from menu order by Menu_Heirarchy

 

Here when i executed this query my resultset is Menu Name is show as (Excluded)

Menu_id    MenuName   

1              (Excluded)

2              (Excluded)

 

why it is like this how can i solve it.this Problem arise when i

/*Space(length(Menu_Heirarchy ) )*/ assign Space Length Like this format when i hard coded the Problem solves.can any one help me

 

Regards,

sajith

Link to comment
https://forums.phpfreaks.com/topic/164635-execution-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.