I have a script that is "backing up" and "restoring" files. Because there are MANY files, many of which have thousands of records, the script takes a LONG time. I really have 2 questions:
1 - I have frozen the screen, but the delete records, import records, and export records status boxes are...
I can get a user's name from a log in page no problem. I have strName = Session ("Username")
I then have if the user name is "guest" (strName="guest") then go to a different server which is my guestbook to log personal information.
Here is the problem, after...
Is it possible to include a cc in a Submit button in Adobe? I know that I can <A HREF="mailto:who@wherever.com?cc=yohoo@somewhere.com"> but I can't get that to work in the URL of a Submit button.
I am NOT an expert in Access and don't even pretend to be, so don't hesitate to "dumb-down" your answers. You will not insult me!
Here goes:
In a table I have 2 fields both of which are numbers - YEAR and MONTH
Now I want to calculate the duration using the formula YEAR + MONTH / 12...
Pardon me - here is the complete code:
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DRIVER={Microsoft Access
Driver (*.mdb)};" & "DBQ=" & Server.MapPath
("fpdb/CryoCathIPR.mdb") & ";"...
I have a table called CurrentDateAndTime. It consists of 1 field and 1 record. The field is called CurDateTime. It has an automatically filled in value from the function Now(). My db will be static not dynamic and this field will store when the db was last updated.
In my web page I have:
set...
Ok gurus -
In a field that is defined as "Yes/No" in Access, how do I make a comparison in ASP? Example:
sql = "SELECT INVEST, REF1CODE, NEWAC1 From AblProc WHERE REF1CODE='2AC20' AND NEWAC1='Yes';"
Having NEWAC1='Yes' gives "Data type mismatch in criteria...
I'm sure Option Explicit is a preference. I personally like it as it keeps me from accidentally typing an incorrect variable name. I did in fact get the necessary code in question working. Still don't know what the cause of the error is/was. I was actually working on getting a Median function...
Okay guys (& gals) I have no clue what happened, but I went back and added 1 line at a time and it know works. Here is the final code for any of you who care. This computes the median of a list of numbers.
<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include...
I have had some WONDERFUL help on some previous questions this morning from
jlsmithprism
BDC2
FesterSXS
just to name a few helping me with several issues. I am now down to this one BIG BUG!!!! I have taken out ALL of my code except for the following:
<%@ Language=VBScript %>
<%
Option...
Now it is even spookier - all I have is
<%@ Language=VBScript %>
<%
Option Explicit
Dim iNumRec
iNumRec = 0
iNumRec = iNumRec + 1
response.write (iNumRec)
%>
and I still get that there is an illegal character. I am going to repost just this in another thread in hopes to open it up...
OKay - I took out EVERYTHING except what pertains to this code and the page works fine. I then copied this to another page. Just plain and dirty - nothing perty. Here it is:
<%@ Language=VBScript %>
<%
Option Explicit
Dim objConn
Set objConn =...
I'm not sure about when the End If got seperated, but it is fixed now. So here is what I have:
Dim tempAge, iNumRec, Median, intMedian, iCounter
Set objRS = Server.CreateObject ("ADODB.Recordset")
sql="SELECT PTAGE FROM Median"
objRS.Open sql, objConn, 3...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.