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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-31 : 19:43:19
|
Achy writes "I am retrieving data from three tables via union. These tables include memo fields. When I display these fields in HTML, only first 4 characters are displayed.... why first 4?..... very strange. Any answers>>>>>>
Thnks,
.Achy
Here is my query.......
SQLQues = "SELECT correct_answer, question, answer_a, answer_b, answer_c, answer_d FROM entry_level WHERE test_id = '"&tid1&"' and (InStr(1, '"&Entrystr&"' , question_id ) <> 0)" &_
" union all SELECT correct_answer, question, answer_a, answer_b, answer_c, answer_d FROM intermediate_level WHERE test_id = '"&tid1&"' and (InStr(1, '"&Interstr&"' , question_id ) <> 0)" &_
" union all SELECT correct_answer, question, answer_a, answer_b, answer_c, answer_d FROM advanced_level WHERE test_id = '"&tid1&"' and (InStr(1, '"&Advstr&"' , question_id ) <> 0)"
"
|
|
|
|
|
|
|
|
Union with Memo fields.