| Author |
Topic |
|
SHARDIK-GUARDIAN
Starting Member
20 Posts |
 Posted - 2009-06-16 : 08:40:43
|
| Hi All,I've made a ASP page that shows the contents of a table I have in my database. But for some reason the page will not show data from one column. I've checked everything I can think of, but no matter what I try it appears that the query is either just ignoring the column or losing the data somewhere.Does anyone know know what might cause something like this to happen?Thanks :)------------------------------------------------------------Was there ever a trap to match the trap of love? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-06-16 : 10:24:57
|
| What is the datatype of the column (is it unicode?).Is it the last column (after a text dataatype maybe?).Does it display a blank column or not display the column at all?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SHARDIK-GUARDIAN
Starting Member
20 Posts |
Posted - 2009-06-16 : 11:06:27
|
quote:
Originally posted by nr
What is the datatype of the column (is it unicode?).Is it the last column (after a text dataatype maybe?).Does it display a blank column or not display the column at all?
Actually my page returns one "row" based on the ID of the Row, then displays the values in a table. This one value is always blank.All columns are "varchar". Compared to the others this one is not "special" in any way I can see.Thanks for helping! :DHave a great day.------------------------------------------------------------Was there ever a trap to match the trap of love? |
|
|
|
SHARDIK-GUARDIAN
Starting Member
20 Posts |
Posted - 2009-06-17 : 05:26:24
|
quote:
Originally posted by nr
What is the datatype of the column (is it unicode?).Is it the last column (after a text dataatype maybe?).Does it display a blank column or not display the column at all?
Here's more info, my noobsishness is now fully exposed :)As far as I know these are the things that are needed to display the record I want to show:1. Dim Value1, Value2, Value32. Value1= oRec("Value1") Value2= oRec("Value2") Value3= oRec("Value3")3. <% response.write Value1 %> <% response.write Value2 %> <% response.write Value3 %>That's all I should need right?Thanks for your help guys :)------------------------------------------------------------Was there ever a trap to match the trap of love? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-06-17 : 05:58:43
|
| Yep, this is all you need...but you might get an error like this if the column name you're using is a reserved word in either sql or asp.- Lumbago |
|
|
|
SHARDIK-GUARDIAN
Starting Member
20 Posts |
Posted - 2009-06-17 : 08:10:16
|
quote:
Originally posted by Lumbago
Yep, this is all you need...but you might get an error like this if the column name you're using is a reserved word in either sql or asp. - Lumbago
The column is called "Comments", which should be OK right?Is there anything else that could cause a problem?Thanks  ------------------------------------------------------------Was there ever a trap to match the trap of love? |
|
|
|
SHARDIK-GUARDIAN
Starting Member
20 Posts |
Posted - 2009-06-18 : 04:08:35
|
| I'm really stuck guys. Does anyone have any ideas? Thx------------------------------------------------------------Was there ever a trap to match the trap of love? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-06-18 : 07:05:28
|
| Have you run the query you're using in the management studio? Does it show the correct results there? If so this is an asp-problem and not sql which we usually provide help for here. However, if you provide the actual asp code you're using we might be able to spot something. -> SQL = "SELECT a, b, c FROM table WHERE a = " & myVariableResponse.Write(SQL)Response.End- Lumbago |
|
|
|
|
SQL to ASP