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 wrote the code for Members of Register. and i use cookie in this code, My database is SQL server. SQL server dosent support the cookies in my codes i dont know why this cause but my codes are working without any cause .
View Replies View RelatedI 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 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 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?
I am using CDONTS to send mail to the user from my ASP application.
However, the code doenst works all the time. I am able to get mails but
nothing happnes most of the time. The code works maybe once in 20 tries.
What could be the reason?
I have a query in ASP that does a select * from table
It doesnt retun all columns!
When i use objRS("columnname") I get blank. This only effects some colums and I fix it by using
select *,missingcolumn1,missingcolumn2 from table
i posted earlier, and the response seemed to be there is
another dll i need to use the cdonts object, i used it
fine for awhile on my old setup, i upgraded to 2k3 and it
errors up as if cdonts isnt an object. So is there a dll
i need to have to use the cdonts object in iis 6 or do i
need to rewrite my code to use cdo? (if so, please provide
asp 3 example on how to send an email with recepient,
sender, body and subject)
I have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine....
And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff...
All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server.
There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
My friedn is using PWS on NT4 machine, its a local machine, whenever he directs to an .asp page, visual interdev starts.
How can we over ocme this.I had solved this problem long time ago. Now i dont remember. Also to install IIS4.0 do we need to install MTS? if yes, where can we get
it?
I'm using SQL Server and I decided to convert one of the fields from nvarchar to ntext. The transition in the manager was all right, but my ASP pages wouldn't display the ntext and there is no error message. I use Code:
<%=rs("Text")%>
to display the ntext...and there is nothing.
I have a database table with several records. Now I am filtering some data based on the "where" statement. If I run the query in analyzer then I get 20 rows. If I run the same query in asp and assign GetRows() to an array, then the array returns only 4. I am not sure if I am using the GetRows wrong. Here is a snipp of my code:
View Replies View RelatedWhen we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
Does anyone know when MS is going to phase out suppport
for ASP (not asp.NET, but classical ASP) in their
operating systems/web servers? For example, they have
already stopped mainstream support for the main tool used
to build ASP pages (Visual Interdev). It is very much
possible that in the days to come , they come up with a
version of IIS which does not support classical ASP.
Does anyone know when that is supposed to happen?
Can ASP support SSL ?Any tools is required ?Or any things has to be installed on server side ??
View Replies View RelatedI've been trying to write a an RSS feed program in ASP, but I cant find any decent or much reference to a good asp/dom/xml example. I want to be able to read AND write XML to a file system on a server. Does DOM support exists for ASP. I want to have full control over the XML like you can in PHP for example saying Node node = root.childNodes()
and then saying somthign like "for each node get child nodes" and attributes and what ever else I can get. The things I found so far are very limited. Does anyone know of anything like this. I've spent all yesterday and today looking and I still havent made much progress.
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
How do I enable my server to support ASP files?Am I even posting in the right thread?
I am running windows server 2003.
Could I enable this server to support ASP files?
Like IIS installed on it. Its not my server, so i dont know all about it or exactly what the company is, but i can upload whatever i want onto it. Im a complete beginner, so can anybody give me some sample code to test if it supports asp?
View Replies View RelatedI have been using ALS for a while, and I want to be able to create my own version, But the only issue I have is being able to track users realtime, ie get what page they are on, how long they have been online, and being able to contact them by throwing a pop-up.
ALS does it but i've tried scoping the coding, but can't find anything.
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
Code:
If checkAttemping = FALSE Then
objRst("Ended")= FALSE 'reset old attempT
I would like to start using Outlook Web Access on my IIS 5.0 server. It has PHP and MySql on there along with their ISAPI filters. Everything works great. It has the ASP support taken off and I would like to re-add this support back to the server.Where is the ISAPI filter located at on the Server?
I am hoping that this would be the only reason that OWA will not work.
In my ASP page I set the charset to UTF-8
Response.charset="UTF-8"
But all the javascript functions included thourgh a .js file does not work. This happens only on IE6.0.28 and works fine on IE5 and IE6.0.26 also. If anyone of you guys have worked on mulitlingual support if u could mail me your ASP page,which uses a charset mail to me.
Is it possible to configure Apache to work with ASP.Net? If so, how do i do it?otherwise, do i have to use IIS for ASP?
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.
I have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
I need to support my web pages both in english and spanish. Is this possible in ASP. Can u please point to some places(websites)/articles which will show that. Or if you have any code Or any leads into it that would be great.
View Replies View RelatedIf application deals with browsers that do not support cookies, then what I will have to use other methods to pass information from one page to another in your application in the ASP.
View Replies View RelatedPlease observe the pages below:
session1.asp
<%
Session("test")="TESTING"
Response.Redirect "session2.asp"
%>
session2.asp
<%
Response.Write Session("test")
%>
Those pages does not output any thing if I use IE and If I access the pages
from machines running Windows 2000 Server, XP or Windows NT Server. Opera
outputs as per session variables name.
IIS server is running Windows 2000 server. I've checked the cookie settings
which was set to accept cookies.
I tried IE 5.0, IE 5.5 and IE 6.0
What could be the fix?