ASP / Active Server Pages Forum

the asp page works fine with with all the other columns other than the AUTONUMBER search and DATE a part of the code is given below <% Dim MyDisplay Set MyDisplay = Server.CreateObject("ADODB.Connection") ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};pwd=password;" ConnStr = ConnStr & "DBQ=" & Server.MapPath("db\mails.mdb")...

I have a Sub that handles the linkbutton Command I would like to do Session("intSomething")=e.CommandArgument where I have previously set the linkbutton commandargument CommandArgument="<%= Purchaser1PersonKey %>" Nothing seems to work Not sure of syntax. Thanks

Hi, I am trying to display a field as currency from a recordset to a text field to my asp page. I am using FormatCurrency vbscript function. Everything works as designed if the field displayed contains a number. However, if the field is null, I receive a VBScript runtime error '800a000d. Below is the code: <input name="txtLastMonthEac"...

I am using the smtp.gmail.com to send mails in my application some times the mails are send the server,It is not all the times .I want to resend those mails.and i want to queue up the mails .can any one help me ?

We are writing test scripts to our product. In one of the script we are facing an issue. This test script will create a COM component and executes the following function. O1 and O2 are out parameters. v2iAuto.ComputerPolicyLevel(False, o1, o2) We are facing issue while iterating through 02 object. O2 contains array of...

when i put some big text in it with asp write method its redirect me to some page an says he cant find the file called 127.0.0.1/and here japanees words many but when i delete some part from the big text and made him to small text he passes and write in the asp file plss help

I have a table called News and each News have a Views value. In my table there are many rows of News. How do I to print the 4 most popular/viewed News?

how to insert special characters into ms acess database along with text below is my example <!--#include file="common.asp"--> <!--#include file="header.asp"--> <% CheckAdminLogin if request("submit")="Save" then OpenDataBase conn newshead=request("newshead") newsdes=request("newsdes")

how to protect my database table field from sql injection so that it cannot be hacked please suggest i m using classic asp to build websites

Hi all Hope someone can help me here. I have a website that i have added a search engine too, it searched results that i have stored into a database. I would really like it when a list of pages from the database is displayed, a user can click on one of them and it will open into an iframe called target="I1". Here is my code, it all...

Hi, I have created a page that browses excel file and another page that should retreive specific column values from this file. Now, this file comes from local computer.So, how to retrieve specific columns values using "FileSystemObject" from it and then store it in SQL table in specific columns. Any sample code will help me. ...

I have a strange date issue in the ASP application. Application displays records from the database along with the record date The same application is installed on two different servers. On both servers application points to the same SQL database accessing it through ODBC connection. This happens on one server only. It doesn’t happen on...

i tired do it alone but its gives me an eror like that: "r object cant move back" here is my code : <% path = Server.mappath("../db/ServerData.mdb") set con = Server.createobject("ADODB.Connection") con.open "driver={Microsoft Access Driver (*.mdb)};DBQ="&path set r = con.execute("select * from News") Dim i

I would like to access an excel file form an asp page. I am using the connection string as, sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""c:\Test\Modified.xls"";Extended Properties=""Excel 8.0;HDR=NO;IMEX=1""" I would like to know how can I put the server name, user name and password and how.....

It is possible create Seasson variable (ASP) through VBscript?

Hi , I have asp page with many includes files , like connection, left and center. I would like to replace my with iframe my page is look like <body> <!--#include file="conn.asp" --> <!--#include file="leftside.asp" --> <!--#include file="center.asp" -->

<% dim fs,fname set fs=Server.CreateObject("Scripting.FileSystemObject") set fname=fs.CreateTextFile("c:\test.txt",true) fname.WriteLine("Hello World!") fname.Close set fname=nothing set fs=nothing %>

Microsoft VBScript runtime error '800a01b6' Object required for 'Session(...)' /OnlineBookStore/AddItemProcess.asp, line 33 I have underlined the error line Code i Used:

How to store images in ms access using asp...That image should be stored in one folder and that path should be stored in ms access...Plz help with code.........

We are writing test scripts to our product. In one of the script we are facing an issue. This test script will create a COM component and executes the following function. O1 and O2 are out parameters. v2iAuto.ComputerPolicyLevel(False, o1, o2) We are facing issue while iterating through 02 object. O2 contains array of...

I have a DropDownList. DropDownList is clicked, the screen on this radio button, button, checkbox, etc. I want the toolbars to come ... Please help me ... like this... http://www.codeproject.com/KB/combobox/CustomDDComboBox/images.png

Good Day Just wanted to ask for any help on how could I count a record depending on the value of the two column. Example below table i need to count the productivity of the agent for march 1 for each telno and for march 2 for each number. the rule is 1 productivity per telno per day. Even they encoded many data for same telno still it count 1....

The answer I was looking for was staring at me. Disregard this post.

Hello, I have a situation using VBScript where I read a table of valid serial numbers and if the serial number cannot be found, blank out the serial number field, display an error message, and reload the page. Listed below is some of the code which would be issued after the valid serial number table is read. ( The error message display is...

Problem is that connecting microsoft access database shows that database is already exclusively opened by another user