Click here to Skip to main content
15,895,746 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionimages Pin
mylogics19-Oct-09 22:02
professionalmylogics19-Oct-09 22:02 
AnswerRe: images Pin
nagendrathecoder19-Oct-09 22:07
nagendrathecoder19-Oct-09 22:07 
GeneralRe: images Pin
Christian Graus19-Oct-09 23:27
protectorChristian Graus19-Oct-09 23:27 
GeneralRe: images Pin
nagendrathecoder19-Oct-09 23:33
nagendrathecoder19-Oct-09 23:33 
AnswerRe: images Pin
Abhijit Jana19-Oct-09 22:50
professionalAbhijit Jana19-Oct-09 22:50 
AnswerRe: images Pin
yesu prakash20-Oct-09 1:02
yesu prakash20-Oct-09 1:02 
AnswerRe: images Pin
carlecomm20-Oct-09 21:26
carlecomm20-Oct-09 21:26 
QuestionThe text,ntext and image data type cannot be compared or sorted except when IS NULL or LIKE Pin
haleemasher19-Oct-09 20:50
haleemasher19-Oct-09 20:50 
here is my query and i use it for making a crystal report when i run it in database MS Access it show the values but same query when i run it in sql server it show error "The text,ntext and image data type cannot be compared or sorted except when IS NULL or LIKE"
there are its datatypes
TotalSale int
Price money
Category Text
Transaction Text

same datatype used in sqlserver and MS access. Plz help

SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
GROUP BY a.Category,a.[Transaction];

AnswerRe: The text,ntext and image data type cannot be compared or sorted except when IS NULL or LIKE Pin
Nigel Ferrissey19-Oct-09 21:01
Nigel Ferrissey19-Oct-09 21:01 
GeneralRe: The text,ntext and image data type cannot be compared or sorted except when IS NULL or LIKE Pin
haleemasher19-Oct-09 21:31
haleemasher19-Oct-09 21:31 
QuestionConnecting to Oracle Pin
v1i9n6o7d19-Oct-09 20:14
v1i9n6o7d19-Oct-09 20:14 
AnswerRe: Connecting to Oracle Pin
Abhishek Sur19-Oct-09 22:25
professionalAbhishek Sur19-Oct-09 22:25 
AnswerRe: Connecting to Oracle Pin
Abhijit Jana20-Oct-09 9:14
professionalAbhijit Jana20-Oct-09 9:14 
QuestionParser error... Pin
RajpootRohan19-Oct-09 19:32
professionalRajpootRohan19-Oct-09 19:32 
AnswerRe: Parser error... Pin
Abhijit Jana19-Oct-09 19:47
professionalAbhijit Jana19-Oct-09 19:47 
GeneralRe: Parser error... Pin
RajpootRohan19-Oct-09 20:28
professionalRajpootRohan19-Oct-09 20:28 
GeneralRe: Parser error... Pin
Abhijit Jana19-Oct-09 21:07
professionalAbhijit Jana19-Oct-09 21:07 
GeneralRe: Parser error... Pin
RajpootRohan19-Oct-09 20:51
professionalRajpootRohan19-Oct-09 20:51 
AnswerRe: Parser error... Pin
sumans432419-Oct-09 20:15
sumans432419-Oct-09 20:15 
AnswerRe: Parser error... Pin
Nigel Ferrissey19-Oct-09 21:28
Nigel Ferrissey19-Oct-09 21:28 
AnswerRe: Parser error... Pin
RajpootRohan20-Oct-09 1:57
professionalRajpootRohan20-Oct-09 1:57 
Questionopen a new window with the specified url on clicking a image in slide show extender ajax control Pin
jknascrimz19-Oct-09 18:46
jknascrimz19-Oct-09 18:46 
AnswerRe: open a new window with the specified url on clicking a image in slide show extender ajax control Pin
Christian Graus19-Oct-09 18:57
protectorChristian Graus19-Oct-09 18:57 
GeneralRe: open a new window with the specified url on clicking a image in slide show extender ajax control Pin
jknascrimz19-Oct-09 19:13
jknascrimz19-Oct-09 19:13 
GeneralRe: open a new window with the specified url on clicking a image in slide show extender ajax control Pin
Christian Graus19-Oct-09 19:27
protectorChristian Graus19-Oct-09 19:27 

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.