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!

  • Congratulations strongm 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. vlitim76

    main window name

    I have a situation where I am using window.open to open a new window and from this window I want to target the opener. Now I can do this using window.opener, but if the user moves the location of the main window to another page and the popup window is moved to a new location on the same site...
  2. vlitim76

    sp_send_dbmail + from address

    Yeah that's what we need it to do. Can't believe they haven't added that sort of functionality, tying it to profiles seem ridiculous.
  3. vlitim76

    sp_send_dbmail + from address

    ok, that seems very annoying. The software we have developed emails people based on certain events, so I create an appointment and you get an email from me telling you so. The way SQL 2005 is setup I would have to create a profile for every user in the system, which when we are talking 100's is...
  4. vlitim76

    sp_send_dbmail + from address

    I am just looking at sending email from SQL 2005, and have a question about the sp_send_dbmail procedure. I need to be able to specify a "from" address, but as far as I can see you cannot do this, but instead have to tie the message to a profile. Can someone confirm this. Cheers Tim
  5. vlitim76

    duplicating row

    pretty much though I am using a date format of dd/mm/yyyy but the principal is the same.
  6. vlitim76

    duplicating row

    basically any row that has a start and end date that differ I need to replicate for every date inbetween.
  7. vlitim76

    duplicating row

    I have a table that has the following info: name start date end date entry1 08/01/2007 10/01/2007 entry2 09/01/2007 09/01/2007 I need to be able to split select multiple entries for the rows that have different dates, so for example I would get: name start date end date...
  8. vlitim76

    dynamic sql

    I have a situation in a stored procedure where I need to call another procedure that could be in different databases. The @extDatabase is being passed from the application and I am currently doing the below. question is can I do this dynamically and not have to do an if statement for each...
  9. vlitim76

    updating a field with multiple column values

    I have the below situation: table1 t1ID t1Name table2 t1ID t3ReqID table3 t3ReqID t3Name Where t1ID can be linked to multiple t3ReqID's. I want to be able to bring back a recordset that looks like: t1ID t1Name requirements where requirements is a comma delimited list of t3Name how do...
  10. vlitim76

    onmouseout + textarea

    I need to know when the mouse has actually left the textarea so I can then save the data and inform the user, at the moment the user is informed wheh you rollover as well which is no good. I need to make sure that I onlt save the data on mouseout. cheers
  11. vlitim76

    onmouseout + textarea

    ok that makes sense, but how can I deal with this so it only fires when the mouse is out of the whole element? cheers
  12. vlitim76

    onmouseout + textarea

    I have some code that is meant to trigger an even when the mouse rolls out of the textarea. This works fine if the amount of data in the textarea does not require a scrollbar, but as soon as the scrollbar appears the onmouseout is triggered when I roll onto the textarea as well. Has anyone got...
  13. vlitim76

    getElementsByTagName + IE

    I am using Ajax and have got it working in Firefox but IE doesn't seem to fill the getElementsByTagName array correctly Below is the end function that gets the data. the xml that is returned to it is <valid>true</valid> function checkDuplicateCaseNo(responseXML) { var msg =...
  14. vlitim76

    Insert Into + Identity

    I want to be able to copy one row in a table to the same table. The table has 10 normal columns and an identity column. Idealy I would like to so something like this, insert into #table select * from #table WHERE id = 1 so that if new columns are added to the table they will be copied across...
  15. vlitim76

    comma delimited to cols

    absolutely perfect, thanks for the pointer.
  16. vlitim76

    comma delimited to cols

    I havea table that looks like: id name status 1 new new,new-rd,hold 2 open open,open-rc and I want to get it out like id name status 1 new new 1 new new-rd 1 new hold 2 open open 2 open open-rc sure I have done this before but can't remember how!? Cheers Tim
  17. vlitim76

    grouping query

    I have a table with the following info: groupID name 1 Tim 1 Jim 1 Brian 2 Sam 2 Mike and I want to return a result set that looks like: groupID name 1 Tim, Jim, Brian 2 Sam, mike any ideas as I am completely stuck on this...
  18. vlitim76

    Branch and Share

    I have a base product that we have in source safe which is quite big (1000's of files). When we get a new customer I need to be able to take a copy of the base version and keep all the history in tact for future updating. I have been trying to use branch and share but it is taking upward of 10...
  19. vlitim76

    HTMLunknownelement + IE

    hi I have a page with a custom element in whcih works fine in firefox but not in IE! <xmlInfo>Hello</xmlInfo> which I am referencing: var root = xmlFile.getElementsByTagName('xmlInfo').item(0); alert(root.firstChild.data); In IE getElementsByTagName('xmlInfo').item(0); returns null...

Part and Inventory Search

Back
Top