Nepokazivajetsa danije s ntext v ASP
ASP nedajot pravelnij rezultat.
Stranica prostaja ASP stranica katoraja dastajot danije iz MS SQL 2000 SP4 cherez recordset. V tablece jesth polje muRating - Real[4] i muDescription - ntext[16]. Jesli v stranice muRating stavith pered muDescription to oba polja pokazivajutsa. Jesli ze muDescription stavith pered muRating to pokazivajetsa tolka muRating a muDescription nepokazivajetsa. V chom problema neponemaju.
Stranica prostaja ASP stranica katoraja dastajot danije iz MS SQL 2000 SP4 cherez recordset. V tablece jesth polje muRating - Real[4] i muDescription - ntext[16]. Jesli v stranice muRating stavith pered muDescription to oba polja pokazivajutsa. Jesli ze muDescription stavith pered muRating to pokazivajetsa tolka muRating a muDescription nepokazivajetsa. V chom problema neponemaju.
Код:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Dim rsMovie__MMColParam
rsMovie__MMColParam = "1"
If (Request.QueryString("muID") <> "") Then
rsMovie__MMColParam = Request.QueryString("muID")
End If
%>
<%
Dim rsMovie
Dim rsMovie_numRows
Set rsMovie = Server.CreateObject("ADODB.Recordset")
rsMovie.ActiveConnection = MM_cnnKinoASP_STRING
rsMovie.Source = "SELECT * FROM dbo.tblMovie WHERE muID = " + Replace(rsMovie__MMColParam, "'", "''") + ""
rsMovie.CursorType = 0
rsMovie.CursorLocation = 2
rsMovie.LockType = 1
rsMovie.Open()
rsMovie_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%=(rsMovie.Fields.Item("muRating").Value)%></td>
</tr>
<tr>
<td><%=(rsMovie.Fields.Item("muDescription").Value)%></td>
</tr>
</table>
</body>
</html>
<%
rsMovie.Close()
Set rsMovie = Nothing
%>
<%
Dim rsMovie__MMColParam
rsMovie__MMColParam = "1"
If (Request.QueryString("muID") <> "") Then
rsMovie__MMColParam = Request.QueryString("muID")
End If
%>
<%
Dim rsMovie
Dim rsMovie_numRows
Set rsMovie = Server.CreateObject("ADODB.Recordset")
rsMovie.ActiveConnection = MM_cnnKinoASP_STRING
rsMovie.Source = "SELECT * FROM dbo.tblMovie WHERE muID = " + Replace(rsMovie__MMColParam, "'", "''") + ""
rsMovie.CursorType = 0
rsMovie.CursorLocation = 2
rsMovie.LockType = 1
rsMovie.Open()
rsMovie_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%=(rsMovie.Fields.Item("muRating").Value)%></td>
</tr>
<tr>
<td><%=(rsMovie.Fields.Item("muDescription").Value)%></td>
</tr>
</table>
</body>
</html>
<%
rsMovie.Close()
Set rsMovie = Nothing
%>
Цитата:
Originally posted by phoeniX79
ASP nedajot pravelnij rezultat.
Stranica prostaja ASP stranica katoraja dastajot danije iz MS SQL 2000 SP4 cherez recordset. V tablece jesth polje muRating - Real[4] i muDescription - ntext[16]. Jesli v stranice muRating stavith pered muDescription to oba polja pokazivajutsa. Jesli ze muDescription stavith pered muRating to pokazivajetsa tolka muRating a muDescription nepokazivajetsa. V chom problema neponemaju.
ASP nedajot pravelnij rezultat.
Stranica prostaja ASP stranica katoraja dastajot danije iz MS SQL 2000 SP4 cherez recordset. V tablece jesth polje muRating - Real[4] i muDescription - ntext[16]. Jesli v stranice muRating stavith pered muDescription to oba polja pokazivajutsa. Jesli ze muDescription stavith pered muRating to pokazivajetsa tolka muRating a muDescription nepokazivajetsa. V chom problema neponemaju.
Код:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Dim rsMovie__MMColParam
rsMovie__MMColParam = "1"
If (Request.QueryString("muID") <> "") Then
rsMovie__MMColParam = Request.QueryString("muID")
End If
%>
<%
Dim rsMovie
Dim rsMovie_numRows
Set rsMovie = Server.CreateObject("ADODB.Recordset")
rsMovie.ActiveConnection = MM_cnnKinoASP_STRING
rsMovie.Source = "SELECT * FROM dbo.tblMovie WHERE muID = " + Replace(rsMovie__MMColParam, "'", "''") + ""
rsMovie.CursorType = 0
rsMovie.CursorLocation = 2
rsMovie.LockType = 1
rsMovie.Open()
rsMovie_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%=(rsMovie.Fields.Item("muRating").Value)%></td>
</tr>
<tr>
<td><%=(rsMovie.Fields.Item("muDescription").Value)%></td>
</tr>
</table>
</body>
</html>
<%
rsMovie.Close()
Set rsMovie = Nothing
%>
<%
Dim rsMovie__MMColParam
rsMovie__MMColParam = "1"
If (Request.QueryString("muID") <> "") Then
rsMovie__MMColParam = Request.QueryString("muID")
End If
%>
<%
Dim rsMovie
Dim rsMovie_numRows
Set rsMovie = Server.CreateObject("ADODB.Recordset")
rsMovie.ActiveConnection = MM_cnnKinoASP_STRING
rsMovie.Source = "SELECT * FROM dbo.tblMovie WHERE muID = " + Replace(rsMovie__MMColParam, "'", "''") + ""
rsMovie.CursorType = 0
rsMovie.CursorLocation = 2
rsMovie.LockType = 1
rsMovie.Open()
rsMovie_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%=(rsMovie.Fields.Item("muRating").Value)%></td>
</tr>
<tr>
<td><%=(rsMovie.Fields.Item("muDescription").Value)%></td>
</tr>
</table>
</body>
</html>
<%
rsMovie.Close()
Set rsMovie = Nothing
%>
А попробуй загнать (rsMovie.Fields.Item("muDescription").Value) в переменную и выводить уже непосредственно переменную
Nu ja pomestil jejo v peremenuju no vsjoravno nechevo krome "22" nevivoditsa (22 dlja kontrolja postavil).
Код:
<td>
<%
dim strDesc
strDesc = rsMovie.Fields.Item("muDescription").Value
Response.Write(strDesc + " 22")
%>
</td>
<%
dim strDesc
strDesc = rsMovie.Fields.Item("muDescription").Value
Response.Write(strDesc + " 22")
%>
</td>
Цитата:
Originally posted by phoeniX79
Nu ja pomestil jejo v peremenuju no vsjoravno nechevo krome "22" nevivoditsa (22 dlja kontrolja postavil).
Nu ja pomestil jejo v peremenuju no vsjoravno nechevo krome "22" nevivoditsa (22 dlja kontrolja postavil).
Код:
<td>
<%
dim strDesc
strDesc = rsMovie.Fields.Item("muDescription").Value
Response.Write(strDesc + " 22")
%>
</td>
<%
dim strDesc
strDesc = rsMovie.Fields.Item("muDescription").Value
Response.Write(strDesc + " 22")
%>
</td>
Значит переменная пуста, вот и все.
Проверь правильно ли ты ввел название поля, и для теста лучше это поле введи через индекс а не через название.
Цитата:
Originally posted by 3D Bob
Значит переменная пуста, вот и все.
Проверь правильно ли ты ввел название поля, и для теста лучше это поле введи через индекс а не через название.
Значит переменная пуста, вот и все.
Проверь правильно ли ты ввел название поля, и для теста лучше это поле введи через индекс а не через название.
No vopros i jest o tom pochemu ono pustoje. Nachinaja temu ja uze pisal sto seli v stranice stavith muDescription i potom muRating to oba polja pokazivajut znachenija. A jesli snachala muRating a porom muDescription to pokazivajetsa znachenije tolka muRating. Nechevo drugova v stranice nemenjajetsa.
Цитата:
Originally posted by phoeniX79
No vopros i jest o tom pochemu ono pustoje. Nachinaja temu ja uze pisal sto seli v stranice stavith muDescription i potom muRating to oba polja pokazivajut znachenija. A jesli snachala muRating a porom muDescription to pokazivajetsa znachenije tolka muRating. Nechevo drugova v stranice nemenjajetsa.
No vopros i jest o tom pochemu ono pustoje. Nachinaja temu ja uze pisal sto seli v stranice stavith muDescription i potom muRating to oba polja pokazivajut znachenija. A jesli snachala muRating a porom muDescription to pokazivajetsa znachenije tolka muRating. Nechevo drugova v stranice nemenjajetsa.
Попробуй вывести данные не по идентефикатору muRating и ... а по идентефикатору 0,1... Я када писал на ASP тока так и делал... И в SQL запросе не пиши *, а напиши нужные поля. Попробуй жестко прописать muID=проверенное значение. Где ты точно знаешь что есть две переменные, сравни результат с результом Query analizer...
Ja proboval i po indeksu. Toze samoje.
Apishu shto jest. Mozet tam ktota uvidit problemu.
Jest:
1. Windows Server 2003 s SP1 i ostalnimi zaplatkami.
2. Dreamweaver MX (7.0)
3. Rabotajet na IIS servera.
4. Podkljuchenije po ODBS (pod System DSN) -> SQL server ...
5. MS SQL 2000 server SP4
V dobavlenom doc faile skript dlja tablici i 3. zapisei, i kod ASP stranici gde vidna sto ntext pered real pokazivajetsa a posle nepokazivajetsa ne po imeni ni indeksu. Jesli ukavota ne len, paprobujte na svojei mashine.
Jesli u vas zarabotajet mozet umenja problemu nuzna iskath v drugom meste.
Na baze MS Access vsjo narmalno rabotajet.
Apishu shto jest. Mozet tam ktota uvidit problemu.
Jest:
1. Windows Server 2003 s SP1 i ostalnimi zaplatkami.
2. Dreamweaver MX (7.0)
3. Rabotajet na IIS servera.
4. Podkljuchenije po ODBS (pod System DSN) -> SQL server ...
5. MS SQL 2000 server SP4
V dobavlenom doc faile skript dlja tablici i 3. zapisei, i kod ASP stranici gde vidna sto ntext pered real pokazivajetsa a posle nepokazivajetsa ne po imeni ni indeksu. Jesli ukavota ne len, paprobujte na svojei mashine.
Jesli u vas zarabotajet mozet umenja problemu nuzna iskath v drugom meste.
Na baze MS Access vsjo narmalno rabotajet.