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 |
keuler
Starting Member
10 Posts |
Posted - 2008-06-22 : 21:34:52
|
All- I'm using the SQL SP below to drive an asp.net gridview. Note how, after "else", I attempt to send to the browser the HTML code that should create a hard space. However, the characters are simply rendered verbatim by the browser. I've tried putting actual spaces in the quotes, and also the SPACE(x) argument. SP test executes appear to show the spaces in the results, but aps.net isn't rendering the spaces at all. Any thoughts.(Its really more of an asp.net question, but I thought I'd post this here too for your thoughts. Thx in advance.)SELECT person_id, male, female, last, CASE WHEN fam_adult = 1 then first else ' ' + first end as first, fam_adult, is_adult, is_kid, is_y_parent_or_kid, is_guest, is_person_type_5, grade, school, is_person_type_6, fam_dadFROM person |
|
LTack
Posting Yak Master
193 Posts |
Posted - 2008-06-23 : 09:22:52
|
Try putting & nbsp; (remove the space between & and nbsp;) to create a space.__________SQL Newbie |
 |
|
|
|
|
|
|