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

    replacing specific elements in strings

    It has been a while since i have used jet sql (mostly use pl/sql). I need to replace specific chars in a string but can't find a method available in jet sql. Example "TASK: "IB732B" FROM QUALITY" I want to replace the &QUOT with a space. I can do this in pl/sql but the...
  2. pyttviper

    Read a File on a local machine using JS

    Thanks for the reply, I was hoping that there way but i see now that there is not. Dan0
  3. pyttviper

    Read a File on a local machine using JS

    Is it possible to read a file on a local machine c:\temp.txt and extract a line from the file into a varible? If it is possible what is the method to use? Thanks Dan0
  4. pyttviper

    script to determine system version (windows9x, nt)

    I am looking for a method to return the local system windows version and enter it in to a variable that will be used by a function. Thanks Dan0
  5. pyttviper

    How to validate a subset of numbers from a bigger set

    I have a textbox which can hold a Road No. Range in the given format [10-15,17,20-25,28] And I have two or three other textboxes in which I need to enter the subset of the range I entered in the Header Road No. Range. The first subset textbox might look like this [10-13], the second might be...
  6. pyttviper

    VB FTP

    I am trying to move away from using the batch file.
  7. pyttviper

    VB FTP

    I have a problem. I have looked at all of the articles i can find about FTPing from a VB program, but I am still unclear on how to implement it in the code. The steps I want to accomplish are: connect to a server (username, password) go to a directory put a file in that directory from the...
  8. pyttviper

    VB FTP COMMANDS

    I have a problem. I have looked at all of the articles i can find about FTPing from a VB program, but I am still unclear on how to implement it in the code. The steps I want to accomplish are: connect to a server (username, password) go to a directory put a file in that directory from the...
  9. pyttviper

    Finding non-distinct duplicate records in a table

    All of these post have helped me come up with a solution to my problem. Thank you Dan0
  10. pyttviper

    Finding non-distinct duplicate records in a table

    I have to find duplicate records in a table where only two of the fields are the same between records. EX sequence F1 F2 F3 F4 1 05943 Service 2920 Tre 2 05943 Customer 2920 Hye I would want to return only...
  11. pyttviper

    Selecting the first occurence of a rowset

    THis example : sample cycle idtype sample_date res1 res2 ------- --- ------ ----------- --- 6861 1 M 05/17/1999 D 6080 1 M 11/17/2000 A P 6140 1 C 01/06/2000 D P 6806 1...
  12. pyttviper

    Stored Procedure Help

    What i want to do is Update a field in a table with new information without deleting the old info. i retrive a record set from a query and set variables for each selected field then pass through the RS and inserts those values into another table. i want to update a field in a second table with...
  13. pyttviper

    Retreiving and inserting records in an SP

    that is exactlty what i needed thanks dan0
  14. pyttviper

    Retreiving and inserting records in an SP

    ...Identifier, Occurrences, Status, LEFT(Notes,20) AS Notes, 'ECB' AS TYPE, DatetimeLastMessageReceived FROM (SELECT Identifier, Notes, Status, COUNT(*) AS Occurrences , DatetimeLastMessageReceived FROM AssetCoordinate INNER JOIN Asset ON AssetCoordinate.AssetKey = Asset.dwKey WHERE...
  15. pyttviper

    Retreiving and inserting records in an SP

    i am running a large query that produces a recordset. what i want to do is put those records into a table but i don't know the syntax to do it this is what i have so far declare @identifier as varchar(50), @Occurrances as numeric, @Status as int, @Notes as varchar(30), @Type as varchar(10)...
  16. pyttviper

    Simple ASP Database Record Add

    when you validate the user and extract the record from the user table set a variable to the username, id etc.. and then insert that info + the date into you log table INSERT INTO Log_table ( Field_User, Field_date) VALUES ('" & strUser & "', '" & strDate & "')
  17. pyttviper

    Returning a Value from a new record????

    you select the max id from the table and display it set rsMax = cn.execute "Select Max(id) AS MaxID from Table" response.write rsMax("MaxID") dan0
  18. pyttviper

    Help with stored procedure

    thanks got it
  19. pyttviper

    Help with stored procedure

    i tried this and i can't get it to work CREATE PROCEDURE sp_ac6000_metric_load AS @uptotal int SELECT @uptotal = count(diffdays)as counts FROM (SELECT ID, Initial_Date, getdate() AS Today, DateDiff(day,Initial_Date,getdate()) AS diffDays, left(Active,1) as active...
  20. pyttviper

    Help with stored procedure

    i am new to SPs and i need some basic answers i wrote the below querie which returns a number but i want to store that number in a variable. CREATE PROCEDURE sp_ac6000_metric_load AS SELECT count(diffdays)as counts FROM (SELECT ID, Initial_Date, getdate() AS Today...

Part and Inventory Search

Back
Top