René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQL Autocomplete doesn't work (5.5.0)","articleBody":"Hi! \n\nWe have a problem on one of our sites. The uComponents SQL Autocomplete datatype is not working. \n\nThe Umbraco version is 6.2.4 (upgraded from 4.7.11) and the uComponents version is 5.5.0 (upgraded from 5.0.0) We havent used the SQL Autocomplete before the upgrade of uComponents and Umbraco - so it is difficult to say if the problem also was pressent before the upgrade. \n\nWe have similar Umbraco setups on other sites where the autocomplete is working just fine (only difference is that the working sites haven't been upgraded but just simply installed from the newest Umbraco versions). \n\nWe are using a simple sql query to retrieve the records from the database. Something similar to this:\n\n`SELECT EmployeeID as Value, Fullname as Text`\n`FROM BookingSystem_User`\n`WHERE Fullname like '%@autoCompleteText%'`\n\nIf we change the datatype to SQL CheckBoxList or SQL DropDownList using the following sql query:\n\n`SELECT EmployeeID as Value, Fullname as Text`\n`FROM BookingSystem_User`\n\nthe datatypes are working just fine.\n\nUsing the console in the browser we can see that no calls are made when typing text into the SQL Autocomplete textbox on a page. On the sites where the autocomplete actually works, we can see that calls are made every time you enter a new letter. Something like this:\n\n`http://www.mysite.com/Base/EE395ED1-CE6E-4417-AEEB-BCA780D3E96B/GetData/1236/4103`\n\nDo you have any clues what could be wrong? \n\nThanks in advance!\n","author":{"url":"https://github.com/jacktinuss","@type":"Person","name":"jacktinuss"},"datePublished":"2015-01-29T11:44:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/28/uComponents/issues/28"}