I'm getting errors when trying to access any Recordset properties and methods
"Object Doesn't support Property error" MoveNext
"Object Doesn't support Property error" EOF
"Object Doesn't support Property error" RecordCount
I'm using a DSN and ADO do I have to change to an OLE DB connection?
why an error like
Object doesn't support this property or method: 'ZoneRS.MoveFirst'
comes up on a page? MoveFirst is a command to move to the first record... correct?
I got this code from a reputable ASP web site:
fs=Server.CreateObject("Scripting.FileSystemObject")
If (fs.FileExists("c:winntcursors3dgarro.cur"))=true Then
Response.Write("File c:winntcursors3dgarro.cur exists.")
Else
Response.Write("File c:winntcursors3dgarro.cur does not exist.")
End If
set fs=nothing
Except everytime I run it, I get an error saying the property or method is not supported?
Can somebody explain me why I get this error
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'Mailer.Response'
/Mailform.asp, line 284
This is the piece of code it refferers to.....
Finally I resolved upload issue. Now I want to add the validation before the upload. So I can make sure it is a JPG file, not any malicious files such as asp. exe. bat, etc..
Set Upload = Server.CreateObject("Persits.Upload")
If Upload.File.ContentType="asp" Then
Response.write "Invalid file"
End if
Upload.Save "k:Inetpubwwwrootpic"
It's not working
Error:
Object doesn't support this property or method: 'File'
I wanted to add this method to my .asp page in order to dynamically choose a
page based upon some selection criteria. It's in my .asp book and in the
online reference. Yet when I use this object, the following error returns
in the browser:
Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Response.Redirect'
/testwebs/choose.asp, line 22
What is missing from my IIS libraries in order to use have this method
supported?
Can't get this to work. I'm creating a workaround for the absence of aspJPEG on my server. I'm using aspUpload but my server only uses aspThumb. After aspThumb optimizes the original pic the file size changes and I need to reflect that change. When using aspUpload I can reference it's built in File object references but they only refer to the "original" file. There's an easy solution when using aspJPEG but not with aspThumb so I'm trying to get the "new" picture size using a scripting object with this script but I'm getting this error.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'objPictureSize.Size'
/admin/media_upload_picture_process.asp, line 107 ....
I have almost completed tweaking vbscript to run on mysql rather than the Access database it was designed for. Trial and error, luck and a bit of detective work have got me this far, however I am getting the following error when tryinf to update existing records in the database.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'RS.Find'
/faq/admin/edit2.asp, line 7
The piece of script looks like this in Dweaver
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "Questions", Conn, 2, 2
RS.Find "ID='" & Request("ID") & "'"
The .Find text is black whereas all other "methods"(?) like the .Open are pink. Is it that the .Find method works with access and not mysql and if so waht is the equivalent or am I barking up the wrong tree?
When I use the following, the RS.recordcount is -1. I also can't do a RS.moveprevious.
What have I overlooked? Code:
CDO (W2k) doesn't support sender's name ? I know this works:
Set objMail = CreateObject("CDO.Message")
objMail.To = Trim(strToEmail)
objMail.Sender = Trim(strFromEmail)
objMail.Subject = "REGISTRATION FINISHED"
But isn't there any support in CDO for the NAME of the Sender ??? Like:
objMail.SenderName = "Mike Jensen"
Because I would not only like to show the emailaddress in the mail I'm sending but also my name .
I can't seem to go through this recordset,method isn't supported on any of the commented out lines, anyone know what my problem is?
Code:
dim objConn
set objConn = server.CreateObject("ADODB.CONNECTION")
objConn.Open "Received", "t", "b"
Dim RS
Set RS = Server.CreateObject("ADODB.Recordset")
dim strSQL
strSQL = "select TOP 15 (requestNumber) as rn from request_received"
RS = objConn.Execute(strSQL)
I've just been caught out by a host that doesn't support #includes in my
ASPs. What's the best strategy for replacing these calls to files that
include everything from subs and functions, global constants, other
#includes, script directives, etc.??
I have a recordset object generated by the command object
as in recordset object=command.execute
now recordset.recordcount gives me -1 !!!!
the actual record count is 7!!!
Any body who can tell em how to change the cursor type of the recordset
which is generated by a command object!!!
i am trying to count the records in an access database, and i cant seem to figure out the syntax to count the records and output a response.write with the number.
View Replies View RelatedI have the following code:
<Script LANGUAGE=vbscript RUNAT=Server>
for i =0 to document.form1.elements.count-1
response.write "test"
next
</Script>
When it gets to the line for i=0.... the error message pops up stating that Object does not support this Property or Method.
When trying to play Yahoo games, I can not get past the following error:
Error: Object doesn't support this property or method
Code: 0
URL: http://games.yahoo.com/games/login2?page=sp
I am running windows 98.2, IE 5.5., Ad-aware,Java 1.42_01
I also have problems clicking on any links, they say done, but go nowhere.
Any solution?
I have a virtual path setup in order to give my web server access
to a file on my app server. I am using the file system object to check
for the existance of the file and if it exists, it has to validate the
file date.
The problem is I can't seem to find the file. I can successfully check
for the existance of a file on the web server, but once I enter the
virtual path it can't find anything. All three of these calls return
false...
fso.FileExists("http://server/localfolder/virtualfolder/test.txt")
fso.FileExists("/localfolder/virtualfolder/test.txt")
fso.FileExists(Server.MapPath("/localfolder/virtualfolder/test.txt"))
However these two calls work, so I assume I am referencing the file
correctly...
Response.Redirect "http://server/localfolder/virtualfolder/test.txt"
Response.Redirect "/localfolder/virtualfolder/test.txt"
Am I doing something wrong here? The virtual path is setup with an id
that has full access to the folder.
This is what I had:
</tr>
<tr>
<td height="10" colspan="5"></td>
</tr>
<% rs.movenext
count = count + 1
loop
%>
</table>
This displayed the items in one column. Then I did this:
<table border="1" width="94" id="table29">
<tr><td width="0"><% rs.movenext()
loop
%> </td>
</tr>
But that display the results side by side in the table and it keeps expanding.. I want to show 3 items across then loop back down to show the next 3...
Like this:
Item1 Item2 Item3
Item4 Item5 Item6
how to make the recordset movenext when the user press next button or movepreviuos when user press move previous button.
In VB, we can directly use rs.Movenext and rs.moveprevious.In ASP, how to do it?
I have radio buttons that I want to disable given the choise had been made (stored in Access DB)It searches only the first value. HEre is the script:
I had already chosen "Bill: Dec-12", the radio button is disabled when I access the page. But when I fill the form and choose "Jack: Dec-13", the next time I go to the registration form - the radio button for "Jack: Dec-13" is not disabled Code:
i need to go to the start of my file, in acsses through asp. how do i do that?
View Replies View RelatedWhen I create a ADODB.RecordSet object and then try to loop through the results, everything works fine, unless when I am done looping through the results I need to call the movefirst on the recordset object. If I happen to have used an ORDER BY in my SQL, it bombs out. Code:
View Replies View RelatedI'm simply trying to get a number of records returned in a recordset, and
just get a -1. I have looke din a few books and other references, can't
seem to find any answers. Anyone have any idea why I can't get a real
number? For the record, the recordset is not empty. In fact, it has many
records which I can see plainly on the screen. But when I do response.write
rs.recordcount, it just shows -1
i tried using a few method from the forum and fail. So anyone can help me out with this, i wanted to count the total number of record in the on of the table Namecard, so tried this code but fail, anyone can help me out? Code:
View Replies View RelatedOur application currently runs on aWindows 2000 Advance server with Oracle 8i and Microsoft IIS 6.0. We are changing servers and will now be running a Windows 2003 server with Oracle 8i and Microsoft IIS 6.0.
The .RecordCount property does not work on the server. It returns a -1. We have not changed any code.
Any idea why this would happen? Are there certain parameters that have to be set to get the .RecordCount to work?
I have an ASP page calling a VB COM calling an SQL Server stored procedure. What I would like is to return a recordset to ASP (works fine) and obtain the RecordCount (doesn't work).
The problem seems to be the difference between adOpenForwardOnly and adOpenStatic of the recordset (adOpenForwardOnly is default and doesn't support RecordCount). Unfortunately, I'm unaware of how to specify adOpenStatic for the recordset.
I've seen the "RS.Open SQL, Connection, adOpenStatic, adLockReadOnly" method, but my recordset is populated by a stored procedure "Set objRS = objCmd.Execute" ... any ideas how I can obtain the RecordCount (short of having the stored procedure return a count)?
Also does it matter where I specify the adOpenStatic (ie, in VB COM or ASP)?
SET objRds = Server.CreateObject("ADODB.Recordset")
objRds.CursorType = 1
objRds.LockType = 3 'adLockOptimistic
objRds.ActiveConnection = objConn
objRds.open strSql
objRds.Recordcount
when i run the srl in query anaylzer, i get records, more than 1 but record count gives me -1 .
I've like to check whether the recordcount equals 0, 1 or greater than 1. I'm still getting to grips with ASP, but hope this isn't too hard. Coming from CF background - have sussed out conditional stuff in ASP, but need to do recordcounts for validation.
View Replies View RelatedI have this:
intTotalNumNewsEntries = rsNews.RecordCount
to count total records in rsnews table, how do i change this to count not all the records, but count the records that has a certain field with a value in it? ie:
intTotalNumNewsEntries = rsNews.somedbfield.RecordCount
I know for a fact that in my database, I have three records under the users
table. However when I execute this code:
I'm using multiple recordsets on a page, and they are all returning correct results and enough of them. My problem is when I try to access the recordcount property rs.recordcount, they all return a result of -1. This would usually mean that no records are returned. So why is showing my recordsets that are displaying records with recordcounts of -1. I can't seem to figure out.
View Replies View Relatedcan anyone tell me why this chunk of code returns "-1"
'dbcnx is database connection
sql = "SELECT * FROM articles"
Set rsArticles = dbcnx.Execute(sql)
rsNumRows = rsArticles.RecordCount
Response.Write("Viewing " & rsNumRows & " record(s).")
even though the db has pulled at least 10 records... i cant figure it out... it has broken alot of my code.. and i've been forced to find different means of making the same code work in asp that i could write quickly in php. i'm trying to learn asp now, and i'm just having problems with this..
I have:
strSQL = "SELECT * FROM newarchive WHERE Program_Title LIKE '%" & program & "%' ORDER BY ID"
set objRS = objConn.Execute(strSQL)
Response.Write "There are " & objRS.RecordCount & " results."
I get -1 for the count on every search.