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

    Custom ticket status in Trac

    I am implementing Trac as project management, and I need a custom ticket status. I have spent the last week or so trying to implement one, but so far I have run into issues with everything I have tried. Can anyone here at least point me in the right direction? The closest I think I came was...
  2. jbellCNS

    How to get general and slow query logs functional?

    I have resolved this issue. I am not certain what it was, but after working with the install I had extensively I did a fresh download and install, and MySql is now behaving as expected.
  3. jbellCNS

    How to get general and slow query logs functional?

    New PostDonQuichote: Thanks for your response. I added the lines you gave to the my.ini file that is being used by MySql, and modified the paths to where I want to store the files. After I did this and attempted to restart the server it failed again, and in the windows log this is what it...
  4. jbellCNS

    How to get general and slow query logs functional?

    I am moving from sql server to MySql 5.6 on Windows Server 2008, and want to log everything for a little bit, especially any slow queries with non-indexed joins. I started with MySql Administrator, but when I check the "Query Logfile" or anything below "Binary Logfile" in the "Log files" tab of...
  5. jbellCNS

    One to many concatenated column

    Thank you all for your input. I believe we have decided on a solution that will not necessitate this functionality in the SQL by moving the responsibility to the server side scripting.
  6. jbellCNS

    One to many concatenated column

    I should clarify: This is the contents of the pane I am executing: DECLARE @str VARCHAR(100) (SELECT @str = COALESCE(@str + '', '') + CONVERT(VARCHAR, [WINDOW_START]) FROM ANC_IND_HIST) DECLARE @dates VARCHAR(50) select TOP 100 [INDIVIDUALS 2].IND_ID, [INDIVIDUALS 2].Ind_Full_Name, (select...
  7. jbellCNS

    How do you dimension these variables?

    ousoonerjoe: Thank you for your feedback. I've looked into the DataSet and DataTable objects like you were talking about, and while it has been somewhat helpful, it hasn't directly addressed the issue I am dealing with. I see it as a three step process. Step 1: Select existing SQL from a...
  8. jbellCNS

    How do you dimension these variables?

    I am re-arranging some sql data, and am having issues building my query. The source table layout is as follows: id filename src value In my program, I know the destination table/col from the src column. There will be many rows in the src table, even for a single update query, and it will...

Part and Inventory Search

Back
Top