Search results for query: *

I am trying to use the following sql statement to update a table based on values from another table. Update grid_master_stg gms set gms.grid_key = (select gm.grid_key from grid_master gm where gm.grid_lvl = gms.grid_lvl and gm.grid_type = gms.grid_type and gm.grid_name = gms.grid_name) where...

i know i need a default namespace or something, but i am getting confused reading all posts and faq's. please help. below is my xml and xsl and asp. the asp page sends a selectsinglenode to search for and returns nothing. i saw a post about this in the faq's but i get confused about...

I have a stored procedure that I can't tell if it is working. <code> alter procedure dbo.confirmcomplete ( @requestID varchar(50) ) as set nocount on; if not exists (select mId from table where mID = @requestID) return(0) else if not exists (select mID from table where mId =...

I am using the createobject("InetCtls.Inet") to ftp a text file. This works on 2 of my 4 computers, but on the other 2 I get the error - cannot create activeX control. The error occurs at this line. Is there a specific file that must be on the computer for the Inet control to work?

Is there a way to make the submit button inactive once the user clicks on it? I am trying to prevent a user from clicking the submit button multiple times when the server is running slow.

Can xor be used in sql statements? If not, is there a way I can get one or the other, but not both to be true?

I have created an activex control, at least I think I have. When I packaged it, it created a htm page which referenced my control like this: &lt;OBJECT ID=&quot;UserControl1&quot; CLASSID=&quot;CLSID:89223550-7CB8-4C85-97DB-AC0C9DD59E4E&quot...

My ASP page needs to query the oracle database looking for a date that meets a particular month and year. I can't seem to use the MONTH nor YEAR functions in SQL. Is there a way around this?

I'm going to be running an FTP application that I create in vb6 the will send some files to a site and then pull some other files from the same site two hours later. This will all be automated, running at night when no one is around. Just the other day, I think I read something that Inet can...

Must I place the Inet control on a form, or can I programatically get it initiated?

By now, I'm as confused as I was when I began this journey. I understand that there is an Inet control, but I am trying use this control without having to have a form to place it on. How do you get the Inet control started? Here is my code: Option Explicit Public Inet1 As...

is there a way to allow a user to press the print screen key to get a file uploaded? i'm thinking, they must first press the print scrn key, then click on a button in the form to paste the filepath to be uploaded from the clipboard. my trouble is, i don't know the path to stored clipboard...

i cannot get this show/hide thing to work. it always shows the first <div>, which is the first table created from a matching value in my recordset. here is my code: <script> function showHide(inDiv) { thisDiv = document.getElementById(inDiv); if (thisDiv.style.display != &quot;none&quot;) {...

Here is the query that is being used for an access database. My trouble is, i am using an oracle database. I don't really understand joins, so can anyone please shed some light on this subject. Thanks in advance. select i.approved, i.assigned_to, i.date_modified, i.date_submitted...

I am trying to make a stacked bar chart with code gathered from asp101. The only problem I am having is that it will not take into account the first record, nor does it add the small numbers. Please take a look at part of my code. I am pulling these numbers from a database, sorting through...

i am using an oracle db. this is my sql stmt. select avg((to_date('10/23/2003','MM/DD/YYYY') - lastuserdate)) from tablename my question is, what is exactly happening? i get a result of 400.509981158606.... what i am doing is taking a date column (lastuserdate) and trying to find the average...

I generate an excel spreadsheet from an asp page with the Response.ContentType &quot;application/vnd.ms-excel&quot; command. One of the fields in the table is a hyperlink, response.write &quot;<td><a href=dataentry_display.asp?&quot; & tRecSet.fields(x) & &quot; target='_blank'>&quot; &...