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!

Search results for query: *

  1. RobColborne

    substring extraction

    Hi I have a field that holds a filepath, e.g. c:\program files\document.doc What I would like to do is extraact the file name, i.e. document.doc I thought I could use a combination of the right and patindex commands to extract this by checking for the first occurence of the backslash from...
  2. RobColborne

    Insert text in another table by using a Trigger.

    I'm trying to create a trigger that will change part of a text field. So, because I can't use text fields from the Inserted table the plan was to copy the inserted fields to a table using a join. So I have the following code, but it won't update the text field, but does update the id field...
  3. RobColborne

    quick sp_changeobjectowner script

    I need to change the owner of some Views after restoring a backup to a different server to user dbo. Because of the number of views is their any way I can do this quickly rather than having to specifiy each viewname with the sp_changeobjectowner command. For example using a wildcard??? Thanks
  4. RobColborne

    Copy variable value to clipboard

    Hi I was looking at an earlier thread that will copy a textbox contents to clipboard, but what I would like to do is copy a variable value to clipboard. How can this be done. The script from the earlier post is as follows: <html><body> <form name="display"> <script language="JavaScript"...
  5. RobColborne

    GoldMine Help Files not working.

    Due to recent MS security updates the GoldMine .chm help file may stop working when opened remotely from a server. The resolution is to copy the following into notepad, save a .reg file and add to the registry. REGEDIT4 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp]...
  6. RobColborne

    Problems with conditional results

    Hi I wish to execute a simple SELECT statement that will evaluate a field that holds either a Y or N value and return either 1.175 for a Y value and 0.00 for a N value. For each row in the result set. Thanks Rob
  7. RobColborne

    Problems with date comparison

    Hi Trying to compare a date in a text field with the current date to check for expiry. Have looked at this forum and thought I have found the answer but having issues. Having put some alerts() in the code the form data returns in the following format: 'dd/mm/yyyy hh:mm', for testing the data...
  8. RobColborne

    Loop thorugh words in Textbox entry

    Hi Can you give me some idea how I can approach the following: I want to write a script that will take the input from a textbox, loop through each word to evaluate it. It will look for know abbreviations and convert to the full word. It will then replace the entry with an updated string. I...
  9. RobColborne

    Check existence or form objects

    I am writing some custom code for an application that allows javascript extenstions. All the code does is to check a passport expiry date. The app displays two screens; a read only summary screen and then a edit screen. On the summary screen the field is hidden and has the name...
  10. RobColborne

    Pasting from Web page into opened Word document

    Hi Is it possible to do the following: Open a word document, select an area of the document switch to a web page and click a button to paste the contents of a text box into the document? So far I have managed to get a script developed that will paste the text correctly but into a new Word...
  11. RobColborne

    Split apart multiline text

    Hi I want to be able to covert a block of text (an address)entered in a multiline text box. Then take each line and place in it's own text box. So the first line will be '10 The Street', next line 'The City' etc Can anyone suggest the best approach to do this. Would I use a regular...
  12. RobColborne

    Conditional update script.

    Hi I have a database set up where a single row is one record consisting of Quantity and Value paired fields. I have a currency field that when changed will trigger an update statement so that the value fields automatically get calculated by the a fixed price(hard coded) dependent of the chosen...
  13. RobColborne

    access to row value in a trigger

    Hi I wish to fire a trigger when a record is updated or inserted in a table. I want the trigger to take the unique ID field of the row being inserted/updated to use to match a row in another table to update a field. I have the basics of the trigger accept that the trigger I have written...
  14. RobColborne

    Type mismatch error on Date field during DTS import

    Hi A BCP import that worked on a SQL server 6.5 has been moves to SQL 2000 using DTS but is getting errors. The original task made use of text files with an accompanying Format file. In SQL 2000, The Bulk Insert task has been set up. However, when the process is run an error is generated...
  15. RobColborne

    Type mismatch error on Date field during DTS import.

    Hi A BCP import that worked on a SQL server 6.5 has been moves to SQL 2000 using DTS but is getting errors. The original task made use of text files with an accompanying Format file. In SQL 2000, The Bulk Insert task has been set up. However, when the process is run an error is generated...
  16. RobColborne

    Failing to find records even though query is correct.

    Hi Got an asp page that has a table which has hyperlinks to open a detailed info of the selected record. This is working in some instances. Because I had problems I stripped down the ASP page to output the SQL query string and the number of records in the record set. When I copy and paste...
  17. RobColborne

    Advice on method to read data from database

    Hi Just need some advice rather than solving a specific problem. I have an ASP page that pulls data from a database into a table. In each row I have a hyperlink that I wish to 'Zoom' which I have workig in a pop-up window. So far I have the link working with the window appearing correctly...
  18. RobColborne

    Characters in database field interferring with script

    Hi I have been working on some ASP pages for a while and all was going well until I had a problem which only after a great deal of time working on having a realised what it is. Unfortunately I don't know how to solve! I am pulling back data from a database in a grid which then has option to...
  19. RobColborne

    Insight into a restore problem with Transaction Logs

    Hi When trying to restore a backup I recieved the error: The log in this backup set begins at LSN %.*ls, which is too late to apply to the database. An earlier log backup that includes LSN %.*ls can be restored. I did plenty of hunting around on the MS kbase and followed an article...
  20. RobColborne

    No data from a simple ASP db Connection

    Hi I am trying to create a very simple ASP page that takes a value from a form into a variable and then displays the results of an SQL query based on that variable. The result should just be a single record. The problem I am having is that the ASP page produces no results. For testing...

Part and Inventory Search

Back
Top