Find Jobs
Hire Freelancers

C++ Function that Converts A Search String into an SQL Query

$30-250 USD

Ολοκληρώθηκε
Αναρτήθηκε περίπου 7 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
We have a C++ / MFC Windows application that stores data in a Microsoft Access format data file. we need a C++ function to help with searching for text in the database. The search conventions below are very similar to the Google Adwords search rules so you can consult them if confused. The function should take a LPCTSTR the user has entered and convert it to a valid SQL query. Lets say the field that will be queried is called: Description So the function would return for the search phrase [dell computer] something like: SELECT * FROM Assets WHERE [Description] = 'dell computer' The format of the text search will be: (1) [Search String] - the data base field must contain EXACTLY what was in between the brackets [ ] and nothing else. So the search: [dell computer] will return only the database rows with a field that contains dell computer if the field contains used dell computer that will not be returned. (2) "Search String" - the data base field must contain the phrase "Search String", it can contain words before or after the phrase: Search String but the phrase "Search String" must be in the Description field. So if the phrase is "dell computer" used dell computer will be returned dell damaged computer would not be returned as "dell computer" must be present in the exact form shown in the quotes. (3) +search a '+' character before a word means the word must be present somewhere in the description field so +dell +computer would return rows containing: dell damaged computer old dell computer computer from dell but would not return dell as the words "dell" and "computer" must be in the description field. (4) -search a '-' character before a word means don't return any rows where the description field contains the word So the search string -queen elizabeth would return rows with a description field containing elizabeth warren elizabeth taylor but would not return rows queen elizabeth queen rock band as they contain the negative keyword: queen
Ταυτότητα εργασίας: 13107565

Σχετικά με την εργασία

25 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hi there, I've vast VC++/MFC experience, and was nearly employed by MS them selves, multiple times. Your C++ function(requirement) is actually not too complicated to implement. If you are keen, let me know.
$135 USD σε 1 ημέρα
5,0 (32 αξιολογήσεις)
6,3
6,3
25 freelancers δίνουν μια μέση προσφορά $164 USD για αυτή τη δουλειά
Avatar Χρήστη
Hello. I am expert in C++, Windows API, MFC and Microsoft Visual Studio. It's my main specialisation. Also, I have knowledge of SQL and I have some experience with Microsoft Access.
$112 USD σε 2 ημέρες
4,9 (984 αξιολογήσεις)
7,4
7,4
Avatar Χρήστη
!!!!!!!!!!!!!!!!!!!!! Hello !!!!!!!!!!!! I am a Computer Vision expert specializing in various Computer Vision techs such as Face Recognition, ANPR(LPR), Vehicle/Pedestrian/Object Counting, General Object Classification, Logo Detection, Emotion Recognition, etc by using C++, Cuda and implementws it in android and iphone. Face Recognition is my team's project and we've built our own SDK which outperforms world's famous commercial SDKs such as VeriLook or Luxand.I'm improving our Face Recognition technique consistently and now have built a Deep Learning based SDK which is surely better than current SDK. ANPR and various Object Tracking & Counting & Recognition techs are also praised by clients & customers over the world. I 'm not only proficient at Computer Vision but also good at other aspects such as Mobile App(Android,iPhone....) & Website development. What is more, I am having a many practical skils. As an expert, I have developed many apps before and published on app store and playstore so have the rich experience in this field. I assure you that I'm ready to work on projects at any time! Thanks and Good Regards. Richard Minh !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!~
$222 USD σε 5 ημέρες
4,8 (57 αξιολογήσεις)
7,0
7,0
Avatar Χρήστη
I am very proficient in c and c++. I have 16 years c++ developing experience now, and have worked for more than 7 years. My work is online game developing, and mainly focus on server side, using c++ under Linux environment. I made many great projects using c++, for example, I made the tools which could convert java codes into c++ scripts, of course garbage collection included, this was very similar to a compiler, and was very complex. I also made our own mobile game using c++, I can show you the demo of client, if you like. I am very proficient in java also. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you.
$120 USD σε 2 ημέρες
4,8 (96 αξιολογήσεις)
6,6
6,6
Avatar Χρήστη
Hello. How are you. I have read and understood the project. I'm an Expert in Data Structures and Algorithms. And I know well ; Java ,C/C++, Python ,SQL. I'm interested this project. So, firstly I want to discuss with you about this project. Then I'll be happy. I wait for your good reply. Thanks.
$200 USD σε 4 ημέρες
4,9 (127 αξιολογήσεις)
6,2
6,2
Avatar Χρήστη
Hi, THANKS FOR THE OPPORTUNITY. Check good reviews from customers I have previously worked for. Its my duty, as I have done here before to deliver on this. Kindly let's start work. I have completed projects in software solutions such as CRMS(Customer Relationship Management Software), lead pages in many known online provided software such as (Zoho, Clickfunnels, Infusionsoft), e-Commerce, Online shops, Payment Integrations such as (Paypal, skrill, Visa, Walletone, GoCardless), Javascript frameworks(Angular JS-This has been used by Domino’s Pizza, Ryanair, iTunes Connect, PayPal Checkout, Google and many companies, React (similar to Flux, Redux), jQuery etc), CSS, PHP(Zend framework, CodeIgnitor, YII, CakePHP,laravel) Java(Servlet API,JavaServer Pages, Apache Struts, Apache Tapestry, Apache Wicket, JavaServer Faces and Facelets, SiteMesh, Spark),Android(PhoneGap,Appcelerator, JQuery Mobile, CoronaSDK, Appbuilder), Ruby, Python(django)).
$83 USD σε 6 ημέρες
5,0 (5 αξιολογήσεις)
5,2
5,2
Avatar Χρήστη
Hello, Im interested to work on this. I have good experience in SQL queries and done many jobs successfully. I gone through your requirements Thanks, Sheik
$100 USD σε 3 ημέρες
5,0 (17 αξιολογήσεις)
5,0
5,0
Avatar Χρήστη
Hi, I have Master Degree in Computer Science. and great experience in C++ and Microsoft Access. I have few questions about project details. First of all, would you be able to provide me the database to test function on it? Also, what are you using to connect to database? Does the project description contains all the required features for function? All of my employers are satisfied with the quality and speed of my work. See my profile to be sure of this. https://www.freelancer.com/u/zabolotniipavel.html If you want to get a quality result done on time - hire me. It will be the best solution for you work. I can start the work right now. Don't lose your money and time. contact me please for more information. Best regards, Pavel.
$45 USD σε 3 ημέρες
4,9 (44 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
Hi, Sir. I am glad to bid you. I have rich experience of C++ developing and I have completed a lot. I have just saw your project and I think I can do it perfectly. I have already do such as C++ functions of searching for text in databases. Please contact me. I'll wait for your reply. Thanks.
$155 USD σε 3 ημέρες
4,7 (4 αξιολογήσεις)
4,4
4,4
Avatar Χρήστη
Hi! I'm senior lecturer on databases with 10+ years experience in different DBMS (including MS Access). Also I'm senior lecturer on designing of compilers, so I can create any parser (as I see you need not difficult string of search). Please tell me what environment you use for your application and may be send ms access database structure for good testing.
$88 USD σε 3 ημέρες
5,0 (19 αξιολογήσεις)
4,3
4,3
Avatar Χρήστη
FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...
$1.000 USD σε 10 ημέρες
5,0 (4 αξιολογήσεις)
3,8
3,8
Avatar Χρήστη
Hi, I do have deep experience in c++ and sql. I will do this job within 1-2 days. I look forward to hearing from you. Regards, Garnik
$50 USD σε 2 ημέρες
5,0 (1 αξιολόγηση)
2,9
2,9
Avatar Χρήστη
Lot of academics, professors wrote lot of articles, books about translation theory and You want it to have for few hundred dollars in freelance? Seriously?
$30 USD σε 1 ημέρα
5,0 (2 αξιολογήσεις)
2,6
2,6
Avatar Χρήστη
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C++, Delphi, Java, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, json, xml, database files as you request. I can start right now
$150 USD σε 3 ημέρες
5,0 (2 αξιολογήσεις)
2,4
2,4
Avatar Χρήστη
Hello, Vast C++ programming experience and in addition to this I have done projects in MFC and for that please see my profile. Furthermore,Please see my profile as i Have great ratting and that shows i can deliver this project. Thanks
$155 USD σε 3 ημέρες
4,5 (5 αξιολογήσεις)
2,3
2,3
Avatar Χρήστη
Hello, I am a senior C/C++ developer and I have coped with several projects, both small and more complex ones. I have a very strong academic background in algorithms and complexity, information systems and in software development. I have an M.Sc. in Computer Science and I work as a software engineer in my day-to-day job. I have very strong analytical and researching skills, as I have a research background (I worked in a technological research center for more than 2 years). I can deliver your project in a week. Looking forward to working with you! Best regards, Michalis
$200 USD σε 7 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi there, I have professional experience with both C++ and SQL. I think I can complete what you asked for in under two hours. My problem is understanding exactly what you want because it's not written in specifications I'm not comprehending. From your description what you're looking for is a function with the following signature: LPCTSTR convertToSQL(LPCSTR string); // return valid SQL from string where string is according to your specs The first part that's confusing is you mention a field of [Description]. Is Description static or where is this supposed to be passed in? So what I'm guessing you mean is LPCTSTR convertToSQL(LPCSTR field, LPCSTR string) // return valid SQL where field matches conditions specified by string My second question is do you plan to mix and match the 4 conditions? Can you give me an example of a complicated string and what you expect it to return and how you expect to call my function. For example: cout << convertToSQL("Description", "+queen -elizabeth"); should print out "SELECT * FROM Assets WHERE Description LIKE '%queen%' AND NOT Description LIKE '%elizabeth%'" Please send me some of the most complex scenarios that you can think of.
$100 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
with comments and easy understanding
$30 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της CANADA
Mississauga, Canada
5,0
32
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιαν 19, 2005

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.