ADODB.Field错误'800a0bcd“ [英] ADODB.Field error '800a0bcd'
问题描述
我在我的.asp文件得到一个错误,我不知道如何解决这个(我不知道ASP,这是我的客户的一个老项目,其他开发人员这样做)。
就是我得到的错误是:
I'm getting an error in my .asp file, and I don't know how to solve this (I don't know ASP, it's an old project of my client, other developer did this). The error what i'm getting is the following:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/br/grava_cadastro.asp, line 105
和行:
100 %>
101 <!--#include file="abrir_arquivo.asp"-->
102 <%
103 xip= Request.ServerVariables("REMOTE_ADDR")
104 RS.Open "SELECT * from visitas where vi_data = date() and vi_ip='" & xip & "'",cn,3,3
105 xlink=rs("vi_link")
106 rs.close
它挡住了我的申请表。有人知道如何解决这个问题?在此先感谢!
It's blocking my signup form. Somebody know how to solve this? Thanks in advance!
推荐答案
您确定您有记录吗?
在行105
你asumming的是一个记录,如果有什么不?
in line 105
you are asumming that the is a record, what if not?
你为什么不加入这样的:
why don't you add something like this:
if rs.eof = false then
xlink=rs("vi_link")
end if
此外,
在SQL行你有这样的:
in the sql line you have this:
RS.Open "SELECT * from visitas where vi_data = date() and vi_ip='" & xip & "'",cn,3,3
但我不知道,如果日期()
应该这样,它应该有与&amp;日期()及'或与&amp;日期()及
(不记得,如果日期被认为是字符串或数字)
but I am not sure if date()
should go like that, it should have '"& date() &"' or "& date() &"
(not remember if date is considered string or numeric)
就应该是这样的:
RS.Open "SELECT * from visitas where vi_data = '" & date() & "' and vi_ip='" & xip & "'",cn,3,3
这篇关于ADODB.Field错误'800a0bcd“的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!