Search results

Hi, I don't know much about how to add records using .AddItem method. This is what I have used but it doesn't work ---------------------------- set con=server.createobject("ADODB.connection") set rs = Server.CreateObject("ADODB.Recordset") con.open "provider=microsoft.jet.oledb.4.0;data...

I have an access database - There are about 1000 records in a table. What I want to do is display 50 records on each page. The code I have used is given below. The problem with this is that it continues until all records are displayed (which means 100 records or so). This not only looks bad but...

In ASP, is there a way to replace characters. What I mean by this is that I have a form in which users can submit their comments. Now what they do is they at times even use the singl-quotation (also known as an apostrophe) in their messages. Now when the message is being added to the database...

i have used the following code on my website: Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open strCon Set rsConfiguration = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT tblConfiguration.* From tblConfiguration;" rsConfiguration.Open strSQL,strCon (this is line 152...

I am using the following code to send email with ASP but I get an error which says: Server.CreateObject Failed emailsend.asp, line 5 <% For Each x In Request.Form message = "my message" Next set smtp=Server.CreateObject("Bamboo.SMTP") smtp.Server="webmail.mywebsite.com"...

I am facing some unknown problem on my server regarding a query. I have used the following query in my ASP page: properlogin="UPDATE MEMBERS SET ProperLogin=True where username='" & username & "'" con.execute (properlogin) This query is running fine on my PWS/IIS but on the site it says that...

I have a table which has got the following fields: Name and Points I want to create a third fieldw with the name of rank which should give automatic results of rank that is the one with the maximum points should have '1' written in his rank column. Similarly, all rank fields should be filled...