June 19, 2008 at 1:40 am
Hi,
Lately i'm working on a project that encounter me an error. i got a attribute column that use ntext as my datatype. Then when i fill in the blank in the asp web, it give me the error say one of my coding variable is undefined. But my coding work well when it does not contain any ' and \ and hit enter button. After we check discover that ntext datatype cannot contain tat special key.
It did submit to our database but when we need to display it using an array then it will be appear the details. but it still work well saving into the database. How can i display it? Pls help for anyone who know or i'll get fired... 🙁
This is part of my coding.. .
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("../users.mdb")& ";Jet OLEDB:Database Password=spsn07;"
set rs = server.CreateObject ("ADODB.Recordset")
set rsOwn = server.CreateObject ("ADODB.Recordset")
rs.Open "SELECT * FROM callRecord WHERE state='Unsolve' ORDER BY callDate", conn,3,3
response.write " " 'store all the ct detail from database into javascript array
response.write "var count="&rs.recordcount&";"
response.write "arr = new Array(count);" 'determine the array size by the record size
response.write "var i=0;"
do while not RS.EOF 'for each ct
rsOwn.Open "SELECT * FROM owner WHERE ownerID="&rs("ownerID"), conn,3,3
response.write "var j=0;"
response.write "arr= new Array(5);" '2 dimentional array: array[0][0],array[0][1],array[0][2],array[0][3]
response.write "arr[j] = '"& rs("ctNo")&"';"
response.write "arr[j+1] = '"& rsOwn("ownerName")&"';"
response.write "arr[j+2] = '"& rs("callDate")&"';"
response.write "arr[j+3] = '"& rs("callTime")&"';"
response.Write "arr[j+4] = '"& rs("location")&"';"
response.write "arr[j+5] = '"& rs("problem")&"';"
response.write "i++;"
rsOwn.close
RS.MoveNext 'next ct
loop
response.write " "
rs.Close
The error we get is a run time error or a system error that appear in the left below corner of the IE. and say count is undefined.
Thank you.
June 21, 2008 at 11:09 am
When exactly does the script stop from working.
According to the IE error, it is when the "count" variable is introduced.
Any mix in lettercase?
Does a select ownerID FROM callRecord instead of select *?
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("../users.mdb")& ";Jet OLEDBatabase Password=spsn07;"
set rs = server.CreateObject ("ADODB.Recordset")
set rsOwn = server.CreateObject ("ADODB.Recordset")
rs.Open "SELECT ownerID FROM callRecord WHERE state='Unsolve' ORDER BY callDate", conn,3,3
response.write " " 'store all the ct detail from database into javascript array
response.write "var count="&rs.recordcount&";"
response.write "arr = new Array(count);" 'determine the array size by the record size
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply