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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hamish75

  1. hamish75

    Frameset Horizontal Scroll

    Thanks for the advice. Ah dinnae ken...
  2. hamish75

    Frameset Horizontal Scroll

    Can anyone help? Thanks. Ah dinnae ken...
  3. hamish75

    Frameset Horizontal Scroll

    I have a frameset where one of the frames links to an external link. The external link page is wider than the frame and is causing a horizontal scroll bar in Internet Explorer but not in Firefox. I want to remove the Horizontal scrolling completely. I’ve spent an eternity trying to find the...
  4. hamish75

    Passing a querystring

    I have the following frameset called index.asp: <frameset rows="55,*,55"> <frame name="top" marginheight="0" marginwidth="0" frameborder="0" scrolling="no" noresize src="header.asp"> <frameset cols="130,*"> <frame name="left" marginheight=0 marginwidth=0 scrolling="no" noresize src="...
  5. hamish75

    TimeStamp less 24 hours

    Thank you. Ah dinnae ken...
  6. hamish75

    TimeStamp less 24 hours

    Hi, I urgently need to create the following in SQL: Delete all records from Bocs.dbo.stats_one where TimeStamp is older than 24 hours and Code begins with "CC" I’m not a million miles away I think!...I have the following where I am selecting: SELECT * FROM Bocs.dbo.stats_one WHERE...
  7. hamish75

    Handle error on edit

    The edit that gmmastros made works great. Just wondering how I could make this inform the user that the field has been clipped if the user enters more than 8000 characters. At the moment below the code posted above I have the following line: Response.Redirect("systems.asp?e=System...
  8. hamish75

    If file exists

    I really just wanted to see an alternative. I wasn't sure if it was the best method. Thanks for your help! Ah dinnae ken...
  9. hamish75

    If file exists

    Foxbox, Do you know if is there another way of doing this without using the ON ERROR RESUME NEXT? Thank you. Ah dinnae ken...
  10. hamish75

    Handle error on edit

    Big thanks for that. Works just great! Ah dinnae ken...
  11. hamish75

    Handle error on edit

    I have a field named [Information text] which is a type varchar(8000). I edit the field in a SQL database here: str_SQL = "" str_SQL = str_SQL & " IF EXISTS (SELECT 1 FROM [System_Information] WHERE SystemID = '" & id & "') " str_SQL = str_SQL & " UPDATE a " str_SQL = str_SQL & " SET...
  12. hamish75

    Scan files to give character count

    Thanks for all the advice guys. Much appreciated. Ah dinnae ken...
  13. hamish75

    Scan files to give character count

    Does anyone know of an example which would allow me to create a small vbs script to scan a folder to check all the text files and then give me a character count? I have been searching the internet for a long time but can't find anything. Thanks. Ah dinnae ken...
  14. hamish75

    If file exists

    Works perfect! Thank you for your help! Ah dinnae ken...
  15. hamish75

    If file exists

    I have the following code that updates a SQL database with a record. This works fine. For i = 0 to Ubound(num) if len(num(i))=2 then rs = "INSERT INTO Model ([BusinessID], [Model Code], [Model Description])" rs = rs & " VALUES" rs = rs & "('" & first_part & "', '" & num(i) & "', '" & "Model...
See more

Part and Inventory Search

Back
Top