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

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


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

Beceriler: C++ Programlama, SQL

Daha fazlasını gör: c program for binary search using function, binary search function in c, query form sql database to show in textboxs c, query form sql database to show in textboxs c#, vba sql query connection string, sql query search xml files, sql php search function, sql query tree children, sql query tree structure, connection string sql express serviceprovider, sql query child child, sql server search zip code, create query query search results php, asterisk call forward database sql query, sql query tree structure records

İşveren Hakkında:
( 22 değerlendirme ) Mississauga, Canada

Proje NO: #13107565



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.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(17 Değerlendirme)

Bu iş için 26 freelancer ortalamada $164 teklif veriyor


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.

in %bids___i_period_sub_35% gün içinde112%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(850 Değerlendirme)

!!!!!!!!!!!!!!!!!!!!! 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 Classifica Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(192 Değerlendirme)

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 environ Daha Fazla

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(68 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(27 Değerlendirme)

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 discu Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(78 Değerlendirme)

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 o Daha Fazla

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(44 Değerlendirme)
in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(53 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)

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 st Daha Fazla

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

Dear Valued Customer I am a full time Senior Engineer developing Enterprise solutions in C++ and .Net Technologies for about 3+ years. I know all the minor details of N-layer Architecture Software Design, Design Patte Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)

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 searchi Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

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 p Daha Fazla

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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?

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)

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, do Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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 delive Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)