Click here to Skip to main content
15,889,724 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: problem creating asp.net project in visual studio 2003 with xp pro Pin
bapu28892-May-10 2:30
bapu28892-May-10 2:30 
GeneralRe: problem creating asp.net project in visual studio 2003 with xp pro Pin
Michel Godfroid2-May-10 2:47
Michel Godfroid2-May-10 2:47 
GeneralRe: problem creating asp.net project in visual studio 2003 with xp pro Pin
bapu28892-May-10 3:06
bapu28892-May-10 3:06 
Questionuser group from active directory Pin
test-091-May-10 7:09
test-091-May-10 7:09 
AnswerRe: user group from active directory Pin
Abhijit Jana1-May-10 8:28
professionalAbhijit Jana1-May-10 8:28 
AnswerRe: user group from active directory Pin
Michel Godfroid1-May-10 22:18
Michel Godfroid1-May-10 22:18 
QuestionHow to access dynamically created Gridview HeaderRow Pin
KittyKit1-May-10 3:54
KittyKit1-May-10 3:54 
Questionsearch query Pin
diyaa_0830-Apr-10 23:50
diyaa_0830-Apr-10 23:50 
sallam 2 all
this is a search query bt i got an exception at column S_No
i.e
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No', Provider_Cpt_Plan_Detail_Id, Provider_Cpt_Plan_Id, pcpd.Cpt_Code, isnull(pc.Proc_Description,'') as cpt_description, pcpd.Cpt_Modifier, Non_Facility_Participating_Fee, Non_Facility_Non_Participating_Fee, Facility_Participating_Fee, Facility_Non_Participating_Fee, pcpd.Deleted, pcpd.Created_By, pcpd.Created_Date, pcpd.Modified_By, pcpd.Modified_Date From Provider_Cpt_Plan_Details pcpd left outer join procedures pc on pcpd.Cpt_Code=pc.proc_code Where ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%' And pcpd.Cpt_Code LIKE '00%' And pcpd.Provider_Cpt_Plan_Id ='100ALLALLALLALLALL' And pcpd.Deleted ='0'


the prob is that i use
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No' in select statement im confused what i give in search where clause if i give S_No it gives me error if i give the whole ROW_NUMBER...etc etc it says it is used only in select statement
now it gives me exception Incorrect syntax near the keyword 'ORDER'.
when i used ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%'


any suggestions what i should do?
AnswerRe: search query Pin
Brij1-May-10 5:54
mentorBrij1-May-10 5:54 
Questionretreving images from database problem Pin
developerit30-Apr-10 22:51
developerit30-Apr-10 22:51 
AnswerRe: retreving images from database problem Pin
Abhishek Sur30-Apr-10 23:52
professionalAbhishek Sur30-Apr-10 23:52 
AnswerRe: retreving images from database problem Pin
Abhijit Jana30-Apr-10 23:53
professionalAbhijit Jana30-Apr-10 23:53 
QuestionGRID VIEW Row command Pin
Amit Patel198530-Apr-10 21:24
Amit Patel198530-Apr-10 21:24 
AnswerRe: GRID VIEW Row command Pin
Peace ON30-Apr-10 22:44
Peace ON30-Apr-10 22:44 
QuestionIntegrating Paypal Pin
Gjm30-Apr-10 15:29
Gjm30-Apr-10 15:29 
AnswerRe: Integrating Paypal Pin
Peace ON30-Apr-10 19:45
Peace ON30-Apr-10 19:45 
QuestionBinding Controls via Generic Method Pin
overtech0630-Apr-10 7:17
overtech0630-Apr-10 7:17 
AnswerRe: Binding Controls via Generic Method Pin
T M Gray30-Apr-10 7:57
T M Gray30-Apr-10 7:57 
GeneralRe: Binding Controls via Generic Method Pin
overtech0630-Apr-10 9:02
overtech0630-Apr-10 9:02 
AnswerRe: Binding Controls via Generic Method Pin
daveyerwin30-Apr-10 11:43
daveyerwin30-Apr-10 11:43 
GeneralRe: Binding Controls via Generic Method Pin
overtech0630-Apr-10 12:01
overtech0630-Apr-10 12:01 
GeneralRe: Binding Controls via Generic Method Pin
daveyerwin30-Apr-10 12:10
daveyerwin30-Apr-10 12:10 
GeneralRe: Binding Controls via Generic Method Pin
daveyerwin30-Apr-10 14:58
daveyerwin30-Apr-10 14:58 
AnswerReturn image from aspx page [modified] Pin
#realJSOP30-Apr-10 3:50
mve#realJSOP30-Apr-10 3:50 
GeneralRe: Return image from aspx page Pin
daveyerwin30-Apr-10 4:40
daveyerwin30-Apr-10 4:40 

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.