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 TouchToneTommy 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: *

  • Users: Iamthestig
  • Content: Threads
  • Order by date
  1. Iamthestig

    SELECT all columns from Grouped By UNION query

    Hi, I'm having trouble returning all the columns from a Grouped By Union query in SQL 2014. I'm trying to return the most recent search closed by company. I should only return 2 records. If I add the extra columns in the Group By clause I get extra unwanted rows. SELECT...
  2. Iamthestig

    Using MAX DATE with Empty Space

    Can someone please help me out with this query. I get a error because one of the rows has an empty space in the YearEnd column. SELECT a.FirstName + ' ' + a.LastName AS FullName, a.Initial, a.Age, b.Level2Company, b.YearEnd, FROM tblContacts a INNER JOIN tblSalary AS b ON a.CREF =...
  3. Iamthestig

    Change td backcolor on RadioButton click

    I have been asked to change our intranet to change the background color of cells when a radiobutton is clicked. There are 160 radio buttons and I'm looking of a way to do this with minimal code changes. Here is an example: <!-- Question 1 --> <tr valign="top"> <td class="style20">...
  4. Iamthestig

    Kill a specific Winword process

    Hi, I'm having a problem with moving word documents from one file to another. If System.IO.File.Exists("Shared Files\CVs\Original CV\" & objContact.OrigCVFilename) And System.IO.File.Exists("Shared Files\CVs\" & objContact.CVFileName) Then System.IO.File.Move("Shared...
  5. Iamthestig

    SET a variable with IF ELSE

    Can someone please help me with this? DECLARE @REF int DECLARE @PreferredEmail as varchar(50) SET @REF = 102108 SET @PreferredEmail = IF (SELECT WorkEmailPreferred FROM tblContactPersonal WHERE CREF = @REF) =1 BEGIN SELECT Email FROM tblContactPersonal WHERE CREF = @REF END ELSE IF (SELECT...
  6. Iamthestig

    How to host PHP/MySQL site

    I have a website written with PHP and MySQL. The company that designed it also hosted it. Now that the hosting is up for renewal, I would like to host it myself on my companies web server. I have been sent the data as a MS SQL Server Query File and the website as PHP files. I don't have either...
  7. Iamthestig

    Using IComparer Class

    Hi, I have a column in a Janus datagrid that shows dates as a string in the format 'mm/yyyy'. 04/2004 03/2006 01/2005 03/2005 01/2008 When I sort this column by clicking the column header I get this result 01/2005 01/2008 03/2005 03/2006 04/2004 which is obviously not want I want. I have...
  8. Iamthestig

    Select Grouped Record

    We have some corrupt data in our tblCompanyHistory table. I need to find the records Grouped by CREF that have a comp_order not starting with 1. Here is some data. CREF Comp_Order -------------------- 8 1 8 2 8 3 9 2 9 3 10 1 11...
  9. Iamthestig

    DropDownList fires MessageBox

    Hi, I'm not sure if this can be done. I am using ASP.Net 2.0 / VS 2008 / VB I have a page with a dropdownlist of user names. When the list is clicked (or before a user name is changed) I want to display a messagebox reminding the user to Save the current Page. Like: "Have you saved this page?"...
  10. Iamthestig

    Fire a Yes/No MessageBox from DropDownList OnPreRender

    Hi, I'm not sure if this can be done. I am using ASP.Net 2.0 / VS 2008 I have a page with a dropdownlist of user names. When the list is clicked (or before a user name is changed) I want to display a messagebox reminding the user to Save the current Page. Like: "Have you saved this page?"...
  11. Iamthestig

    Manipulate String

    Hi, can anyone help me convert this string: 'German. Speaks Spanish Fluently, Dutch Fluently, English Fluently, Italian Advanced, French Advanced.' INTO 'German. Speaks Spanish, Dutch, English Fluently, Italian, French Advanced.' The string could be any combination of languages, the only...
  12. Iamthestig

    SQL String manipulation

    Hi, Using T-SQL, can anyone help me convert this string: 'German. Speaks Spanish Fluently, Dutch Fluently, English Fluently, Italian Advanced, French Advanced.' INTO 'German. Speaks Spanish, Dutch, English Fluently, Italian, French Advanced.' Many thanks
  13. Iamthestig

    Open Word docs, but skip those with macros or locked.

    Hi all, I have a simple programs that loops through a directory of word documents, opens the document and changes the template pathname. This works fine except when the document is locked by another user or contains macros that launches a form. My program will wait for a response from these...
  14. Iamthestig

    Select 2 columns into a Cursor

    Hi everyone, Here is my function: DECLARE @CursRef integer DECLARE @MeetText varchar(1000) DECLARE @MeetName varchar (51) DECLARE @MeetDate char(11) DECLARE CursorMeet CURSOR FOR SELECT CONTACTCREF from tblMeetingDetails WHERE CLID=@CLID and CREF=@CREF AND DETAILTYPE='MEET' ORDER...
  15. Iamthestig

    Remove Macro from a document

    I have a number of word docs with macros which generate report data from sql. Our users generate these documents and then often email them to clients. Depending on the email recipients email server, the attachment can be blocked due to it containing macros. Is there a neat solution to sending...

Part and Inventory Search

Back
Top