I connect to a Access DB and when trying to display the data from the DB, I get the followig error:
Object doesn't support this property or method: 'Fields'
The recordset does not support this property.
The script that I use is attached along with this thread.
Does anybody know what is wrong, is there a simpler approach to
display Access data on a Web Page?
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 just had my hosting provider to add write permissions to this database but I am still getting the following error Quote: ADODB.Recordseterror '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Code:
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 have read post after post after post on how to fix this problem and nothing seems to work for me. I have also been on the phone with my hosting company and all permissions are set to writable and modifyable. Here is the code for my UpdateHandler.asp page. which returns the following error:
ADODB.Recordseterror '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /members/UpdateHandler.asp, line 51
I am using access 2003 database. Code:
I'm trying to use a paging recordset with MySQL.
My connection:
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=mysql1.7host.com;PORT=3306;Database =mydbname;Uid=dcleslie;Pwd=mypassword;OPTION=3;adO penDynamic;adLockOptimistic"
the error I get is:
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. any ideas?
ADODB.Recordseterror '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /group13/parts.asp, line 42
so that is my error message....
this is the code in question...
<% rsPART("COST")= formatCurrency(rsPART("COST"))
response.write(rsPART("COST"))
%>
rsPART calls a table in access and i think the rest is self explanatory. the data type in access is already set to currency. so how do i get "cost" to display in a currency format? is there another way to format currency?
there is a property in asp.net called autopostback, what i want is to set this property
on plain asp to give a combo the ability to postback the selected option.
Is this possible???? i need to set something like that to a dinamic combo, any ideas????
If it can be done in java or vbscript just please tell me, cause i don�t have a clue if is possible or not.
I don't understand why but If I use vbscript the following code works
fine:
....connection string.....
dbConn.Open
msgbox dbConn.Property
but the corresponding code in asp:
...connection string.....
dbConn.Open
response.write dbConn.Property
returns the error "Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another" In both cases
connection to sql server is ok.
I have a requirement like this.When the textbox gets focus..at this even i want to change the input langauge settings.like arabic.
Currently i have to do it manually by pressing the Alt+Shift key..to toggle between twon langauages
when do u use property procedure for example
PublicProperty CompanyName() AsString
Get
Return strCompany
EndGet
Set(ByVal Value AsString)
strCompany = Value
EndSet
EndProperty
I've created a form and I want to add a timestamp to it. How do I do this? I'm using dreamweaver by the way.
View Replies View RelatedI have a few server controls on my page. Also I have a aspropDownList with AutoPostBack="True". When I select any value from the dropdownlist I want all the controls to be empty when my page reloads.
Can I use the EnableViewState property for this or I have to write specific code to do this? Currently the values which I had enetered in the servier side controls are retained after the postback.
does anyone know how to change dynamically a property in some word documents?(in vb, javascript or even if you've got a tool or something )
For example:
In my directories I've got docs with a property "version" I want a tool to update each "version" in my files...
Is there any way to make visiblitiy a combo box (2) in asp false when i used combo box (1) to select one item in the combo box(1) i want to make a combo box(2) which should be made visible false .
View Replies View RelatedI'm using the Microsoft.XMLDOM object in an ASP page to read an incoming XML post request and respond to it. Although the XMLDOM object verifies the XML at a basic level, I want to make sure that the request is in the correct format (as per the specification I have to work to), as well as making sure that any XML at all was sent successfully.
At the moment, I'm stuck at the point of just trying to make sure that an XML request was sent at all. Here's the code I'm using. note that I'm loading the XML from a file for ease-of-testing, but am giving a bad filename so as to create the condition where the XML didn't load successfully.
I got the following error when access an asp page.
Response object error 'ASP 0185 : 8002000e'
Missing Default Property
/downtime_category-old2.asp, line 0
A default property was not found for the object.
I am using asp/vbscript/ado/mssql.
I am able to get the nullable property OK when generating a recordset
with a simple SQL statement such as "select Fld1,Fld2 from Table1" and
then looping thro' the fields and :-
Response.Write(rs.fields(x).attributes and adFldIsNullable)
When I use the following statement all fields are erroneously reported
as nullable:-
"Select B.Fld2, B.Fld3 From Table1 A Left Join Table2 B On
A.Fld1=B.Fld1"
Is this normal?
How can I set the amount of Response.buffer? How can I block scripting if the buffer gets more than 2mb?
View Replies View RelatedI want to disable text box property so user can't modify that perticular text box value in HTML form.I do not want to use label.how to disable text box property in HTML form.
View Replies View Relatedhow could I know if a specific sessionid still exists or not. If there is a method or anything that can tell me about the existence of a specific sessionid .
View Replies View RelatedI am using CDONTS in an ASP program to accept input from a Form and send an E-mail.
The form includes the following as well as some other information :
From (the name of the sender)
To ( the name of the recipient)
From E-Mail ( the senders E-Mail Address i.e. the Reply to address)
To E-Mail ( The recipient's E-Mail Address )
I am having trouble with two properties. What property do I use to set the From (the name of the sender) ? What property do I use to set the From E-Mail ( the senders E-Mail Address i.e. the Reply to address) ?
On my webpage I have a textbox. I would like to be able to change the text in the textbox and via a pushbutton have the value in the textbox written to the .text property so that next time the page is viewed the new value will be displayed.
View Replies View RelatedI'm opening a recordset with a SQL statement and then trying to use the .RecordCount property to count the number of rows in the recordset. For some reason, it is always returning -1. Code:
View Replies View RelatedI have installed on my web server the aspsmartmail component v.2.7.
All work fine, but I have only on problem...
Can I specify the mail server port with the "ServerPort" property?
On the web I read:
....
Set objSmartMail = Server.CreateObject("aspSmartMail.SmartMail")
objSmartMail.Server = "myserver.mail.com"
objSmartMail.ServerPort = 21
...
The last line return a "Object doesn't support this property"
How can I specify a specific port with this object?
I have a standard ASP Textbox control on my form and need to set the readonly property of it using javascript. It's not essential that I do it via client side script but would look a lot better.
View Replies View Relatedwhy is the DefinedSize of the Field object of type adInteger returning the
value 4 and the same property on a adVarWChar type field (Text in MS Access)
is returning the max length of the string that it may contain (for example
52)?
I am trying to dynamically generate links on a webpage base on a list of file using their title property as the link text. My problem is I don't know how to get the title property of the file. Is there a object or dll i can use?
View Replies View RelatedIs it possible to test a string column for null in the filter property of a RecordSet object?
rs.filter = "display = '' "?
This doesn't return any rows.