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...
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.
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...
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...
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.