yeah, that looks like what is going on. now i have to figure out why there are duplicate in a table that is not supposed to be holding duplicates.
thanks for all the help!!
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...
Can't you use a DataSet? Within your dataset, you can hold multiple tables, one table for each dropdown. This would only be a single connection to the database, run all your queries, and then close the connection.
It seems that i have figured it out late last night. My stored procedure does return an integer value. What i ended up doing was setting up a returnvalue parameter in my asp page. This allowed me to get the 'Return()' value from the stored procedure.
but to use those properties, i must return a recordset, right?
That is not what i want to do. I only want a single value returned that i check against a case statement.
After thinking, I shouldn't have to create an output parameter right? Can't you use the return command to return an interger value and use either executescalar or executenonquery?
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?
This is what I have now:
<input type='submit' name='Submit' value='Submit' onclick="value='Wait.. Processing Info..';">
I would like to keep the value change, but now include the disable feature. Now I've added this:
<input type='submit' name='Submit' value='Submit' onclick="value='Wait...
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.
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:
<OBJECT ID="UserControl1"
CLASSID="CLSID:89223550-7CB8-4C85-97DB-AC0C9DD59E4E"...
wow, lots of responses. that's great! so BJCooperIT's solution will work, even if the oracle datatype is a date with the date and time stamp?
Ion Filipski, I am using OO4O. What syntax are you talking about, the BETWEEN? I think when I use BETWEEN, I'm not getting the last date included. I...
That won't work because the oracle field is a date datatype. Since I couldn't get other functions to work, i managed with this:
dateSelected = request.form("month") & "/01/" & request.form("year")
dim sql, RS
sql = "select * from oracle.table " &_...
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...
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.