Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jlindahl

    Can't get update to work using 2 tables

    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!!
  2. jlindahl

    Can't get update to work using 2 tables

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

    confused about xsl and selectsinglenode

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

    Can't Figure Out If anything is returned

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

    DataAdapter, DataView, DataTable?

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

    Can't Figure Out If anything is returned

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

    Can't Figure Out If anything is returned

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

    Can't Figure Out If anything is returned

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

    Can't Figure Out If anything is returned

    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?
  10. jlindahl

    Can't Figure Out If anything is returned

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

    error - cannot create activeX control

    any idea what that file might be?
  12. jlindahl

    error - cannot create activeX control

    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?
  13. jlindahl

    Make Submit Inactive

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

    Make Submit Inactive

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

    XOR

    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?
  16. jlindahl

    need help using my ActiveX control.

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

    SQL Date Functions for Oracle

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

    SQL Date Functions for Oracle

    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(&quot;month&quot;) & &quot;/01/&quot; & request.form(&quot;year&quot;) dim sql, RS sql = &quot;select * from oracle.table &quot; &_...
  19. jlindahl

    SQL Date Functions for Oracle

    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?
  20. jlindahl

    Is Inet dependable or Winsock better?

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

Part and Inventory Search

Back
Top