Recent content by jlindahl

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...

So all i have to do is set my variable to an object datatype? I will give that a try this evening.

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.

That is what i thought too, but i could not read the returned value.

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 =...

any idea what that file might be?

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.

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?