Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MistaT2000
Starting Member
3 Posts |
 Posted - 2009-01-22 : 11:52:23
|
Hi folks, I have a Sqldatasource connected to a RadGrid and this is my query:SELECT "DATESTAMP", "QUICKCALL_KEY", "DESCRIPTION", "TYPE" FROM "SERVICEREQ" WHERE ("QUICKCALL_KEY" = :QUICKCALL_KEY) AND "DATESTAMP" > (SELECT TRUNC(SYSDATE) FROM "DUAL")In the TYPE column in the db there are 3 values, 3,0 and 8. What i need to do is this:if (TYPE=='3'){channel="Phone";}elseif (TYPE=='0'){channel="E-Mail";}elseif (TYPE=='8'){Channel="SMS";}Any help would be superb Amigos!!  |
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2009-01-23 : 06:12:14
|
| What is channel?And why is ur query column names in quotes? |
 |
|
|
|
|
|
SQLDatasource to RadGrid SQL Code Help