Search results for query: *

Ah, ok. Well, I'm afraid that's all I've got (I'm fairly new to Visual Studio myself... have only been using it for a couple months). :-) And 2017 community is the only edition I have any experience with. If anybody else has any ideas? Katie

It sounds like you're saying that the code above works fine (loading the combobox), but then breaks when you click the Register button. What's the code for that button's click event? Katie

I'm not sure, but this sounds to me like a printer issue. Did a google search for local printer delay, and found this: (In Windows 10, you find this by opening your start screen, typing "Printers," opening "Printers and Scanners," left-clicking on your default printer in the list, go to...

I'm assuming you're using Visual Studio? I think you have to have Visual Studio in order to do it. Community Edition, which is free, is sufficient. You open the solution, then choose either "Build Solution" or "Rebuild Solution" (not much difference if you haven't changed any of the...

Just checking: have you rebuilt the solution? Katie

Hi, I have what may be a rather complicated issue. I have an extended gridview control that I swear used to work all the time, but I went away for a while, came back, and it doesn't work anymore (I'm the sole programmer). The extended gridview is designed so that it always shows a footer row...

Unfortunately, the library of PDFs is customized for each client, and can be limited by searches (or not) as well, so having a standard PDF library won't work. It's also always changing. I'm not too concerned about it crippling the server, because the number of client logins who even have access...

Hi, I have a client who wants their clients to be able to download their entire library of large pdf files from the website. So I've written code that is supposed to iterate through a query, add each file in the query to a temp zip file, and when the total number of files reaches 200, it's...

Thanks. That part's already done, though. The question is whether it's possible to rank exact phrase matches as more relevant (while at the same time requiring all words be present in the returned records, and without limiting to exact phrase matches only). Katie

Unfortunately, no. That would be simpler. Using the above "acetate solution" example: A search for acetate solution can only return records where both "acetate" and "solution" appear in the name. If only one of those words appears in the name, then it should not return the record at all...

Regarding the OP, according to https://stackoverflow.com/questions/5003869/error-1064-in-trigger-creation-in-mysql (I'm not too familiar with MySQL triggers, so I looked it up), a trigger is not the same thing as a stored procedure, so there's no need for BEGIN... END. So... the syntax would be...

In case anybody else has a similar problem, thought I should share the workaround. It really was a workaround, thanks to being on a shared server. It was pretty complicated, and my code is kind of difficult to read, so I'll just sum up the logic. Basic gist is, if a search term is less than 4...

I think you may be overthinking this? Especially since it needs to be dynamic, it seems it would be easier to do something like this (untested): SELECT section, item, ct FROM ( SELECT 'Colour' AS section, colour AS item, count(ref) AS ct FROM products WHERE code = 'xyz' GROUP BY colour UNION...

Hi, So, I've got a table with a fulltext index, and my client wants search terms to be exclusive (that is, all search terms MUST be included in the record, or the record should not appear in the search results). So I've got the query set up as a boolean-type query (because, AFAIK, that's the...

Good... glad to hear there's progress! :-) However, looking at your query, one thing leaps out at me, that means it's not going to continue to work, at least not as it is right now. It's in this line: CASE WHEN DATE_FORMAT(HD_TICKET.TIME_CLOSED, '%m/%d/%Y %H:%I:%s') >...

ChrisHirst: Unfortunately, I'm on a shared MySQL server. I can't just change the engine from MyISAM to InnoDB, nor can I change the storage/myisam/ft_static.c file. The problem persists when running the searches in boolean mode - in fact, my original queries that the client was talking about...

You want the other variant of CASE...WHEN, in that case. Take out the HD_TICKET.DUE_DATE between CASE and WHEN: select HD_TICKET.ID, HD_TICKET.TITLE , HD_TICKET.DUE_DATE , DATE_FORMAT(HD_TICKET.TIME_CLOSED, '%m/%d/%Y %H:%I:%s') as TIME_CLOSED, CASE WHEN TIME_CLOSED...

Update: Found the problem, not the solution. Apparently, "better" is a full-text stopword. Found here: https://dev.mysql.com/doc/refman/5.5/en/fulltext-stopwords.html This sucks. No way is my host going to agree to edit the storage/myisam/ft_static.c file, because that could mess up some of...

Update: Ok, the problem, bizarrely, seems to only occur with some words. This query returns the following result (among others): Code: SELECT * FROM CONTENT_Chemicals WHERE Match(ChemicalName, CommonName) AGAINST ('degreaser'); Result: # ChemicalID, ChemicalName, CommonName, DateCreated...

Hi Marclem, My code should be used as a template. I made a lot of assumptions about how your data is stored, which may be correct. But the big thing is, there shouldn't be a comma after "CASE HD_PRIORITY.NAME", or after the lines following: CASE HD_PRIORITY.NAME WHEN 'High' THEN...