Search results for query: *

I have a collection of fields in a database that are input as text (trying to change the field type to date/time or number causes the db to erase the data in those fields). The format is hh:nn:ss. I need to turn those fields into minutes. So if I have 60:10:00 I need it to say 3610. Any help...

I have a SELECT statement that I'm using to generate a table. One of the variables in the statement comes from a form field "item". The form field is carrying the value to this page correctly and the column in the table does exist, but I'm getting the following error message when the code runs...

The objective is to copy a table on button click and then remove it from the page. When a 2nd button is click, I want to put that table back on the page with everything intact. This includes all entries users may have placed into the forms. What I have so far: SUB ResolutionOFF_onClick()...

What I'm attempting to do is cycle through one table and use the values there to write to another table. The problem is that It's not looping. I only get the first record to write and none of the records that follow. Any help is greatly appreciated. <!--#Include...

I need some help with dividing by time. What I have is as follows: Value A: 31027 (Contacts) Value B: 4507:17:03 (4507 hours, 17 minutes, 3 seconds) I need to take Value B and format it in hours, so that it reads (example) 4507.25 hours. Then I need to divide the contacts by the hours to...

I have never done this and don't even know where to begin. What I need to do is write a script that copies an entire Excel Spreadsheet to an access table without over-writing the existing data. Also the Excel sheets I'll be pulling from lack consistency from cell to cell. The first several...

I have never done this and don't even know where to begin. What I need to do is write a script that copies an entire Excel Spreadsheet to an access table without over-writing the existing data. Also the Excel sheets I'll be pulling from lack consistency from cell to cell. The first several...

This is something new to me that I've been challenged with by my superiors. I've been able to set up an ODBC connection to an Excel spreadsheet on my server, but don't know how to call the data from the spreadsheet since there are no column headings. Do I just reference A,B,C,D like I would...

ThisYear = Year(Now()) SQL = "SELECT " SQL = SQL & "[JAN]=SUM(CASE [EntryMonth] WHEN '1' THEN [Instance] END), " SQL = SQL & "[FEB]=SUM(CASE [EntryMonth] WHEN '2' THEN [Instance] END), " SQL = SQL & "[MAR]=SUM(CASE [EntryMonth] WHEN '3' THEN [Instance] END), " SQL = SQL & "[APR]=SUM(CASE...

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. /money/save.asp, line 6 <% IF request.form("Dollars") > 0 THEN objrec.open "Money",objcon,3,3 <...

Here's what I want to do: <% SQL = "SELECT * FROM SCORE WHERE SUPID='"& request.form("SUPID") & "' " SQL = SQL & "AND YEAR1 = "& request.form("YEAR1") &" " objrec.open SQL,objcon,3,3 objrec(request.form("COLNAME")) = request.form("ITEMVALUE") objrec.update %> Is this something that can be...

Here is the script I'm working with: FName = request.querystring("FName") LName = request.querystring("LName") YEAR1 = Year(Now()) SQL = "SELECT * " SQL = SQL & "FROM SCORE WHERE SUPID = '"& request.querystring("SUPID") &"' " SQL = SQL & "AND YEAR1 = "& YEAR1 &" " objrec.open SQL,objcon,3,3...

Here's the code for some math I need done on my page: FOR i = 5 to objrec.fields.count - 1 IF objrec.fields(i).value > 0 THEN thecount = thecount + 1 fieldvalue=objrec.fields(i).value AHTC = objrec("JANAHTC") + objrec("FEBAHTC") + objrec("MARAHTC") + objrec("APRAHTC") + objrec("MAYAHTC") +...

The error I get is this: Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method: 'response.cookies(...)' /interactive/getlogon.asp, line 12 <% SQL = "SELECT * FROM [Emp Data] WHERE VZID='" & request.form("VZID") & "' " objrec.open SQL,objcon,3,3 If...

I have a page where users are required to sign in. When they sign in, cookies are written to the user's system so I can use the data on other pages. What I'd like to accomplish is to check the user's system for the existence of a specific cookie before they're sent to the login page, so that...

I get the following error anytime I try to access my database now. It's never happened before. Just sprung up. Every bit of research I've done says to edit the permissions, but I've done that and everyone has access. Is there anything else that might be wrong? Microsoft OLE DB Provider for...

The following set of scripts is used to pass information from a dropdown box to another ASP page in a querystring. For some reason, the values are not being carried to the next page and I can't figure out why. Any help will be greatly appreciated. <script language="VBScript"> sub...

I'm trying to select the MAX(ID) of a table for a specific user. The code I'm using is: <% VZID1 = request.cookies("ECT")("VZID") SQL = "SELECT MAX (TID) AS MAXTID FROM workflow " SQL = SQL & "WHERE VZID = '"& VZID1 &"'" obrec.open sql,obcon,3,3 <------Line 19 %> I get this error...

This is the script: <!--#Include file=&quot;../../Includes/OpenDBConnections.asp&quot; --> <!--#Include file=&quot;../../Includes/UserInfo.asp&quot; --> <% Jurisdiction = request.form(&quot;Jurisdiction&quot;) myNow = formatdatetime (DateAdd(&quot;h&quot;,1,Now),3) SQL = &quot;SELECT...

I have the following script (let's call it script1): <script language=&quot;VBScript&quot;> Sub B1_onclick 'MsgBox &quot;Did you make a sales attempt?&quot;,308 'IF 6 THEN Info.Submit() 'IF 7 THEN location.href &quot;toolmidtop_savenosale.asp&quot; r = MsgBox (&quot;Did you make a sales...