Error database

Question

0.00/5 (No votes)

See more:

I have this code:

CommandText = "SELECT * FROM ContactsData WHERE VandutLaData BETWEEN LIKE %" + Converter.Encrypt(lblDataDeLa.Text) + "% AND LIKE %" + Converter.Encrypt(lblPanaLaData.Text) + "%";

but i get the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE  %FBKEHKEIKFFKEHKFAKEIKEJKEI% AND LIKE %FBKEHKEIKFFKEHKFAKEIKEJKEI%' at line 1

What am I mising?

Posted 4-Jul-10 11:48am

Aciobanita Costel

Updated 4-Jul-10 11:56am

Kristian Sixhøj

v6

Add a Solution

Comments

Ankur^\m/ 5-Jul-10 0:40am

I guess the answer by Martin solved your issue. Please select "Accept Answer" which would mark the question as 'solved'.

3 solutions

Solution 2

I change my code to:

CommandText = "SELECT * FROM ContactsData WHERE VandutLaData BETWEEN LIKE \'%" + Converter.Encrypt(lblDataDeLa.Text) + "%\' AND LIKE \'%" + Converter.Encrypt(lblPanaLaData.Text)+ "%\'";

but now a get the eror:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%%' AND LIKE '%%'' at line 1

I see there is a problem with the quotes, the probleme is at the end LIKE '%", but my code is right. I hope so.

Posted 4-Jul-10 20:01pm

Aciobanita Costel

Updated 4-Jul-10 20:03pm

v2

Comments

Martin Jarvis 5-Jul-10 9:47am

That looks like it's being cuased by your text fields being empty. % is a wildcard character so %% makes no sense. Maybe you could do a replace on your final string to replace '%%' with '%'.

You'll probably want to check that BETWEEN supports LIKE constraints. I don't think TSQL supports them.

Aciobanita Costel 6-Jul-10 2:55am

I think that is the problem BETWEEN LIKE,

I try to make a select from database, to select all filds from to Data time,

i will try to find a other to do that.

tanks for reply.

Solution 3

I use to have this problem, but SQL support for sure the Like command.
This is what I’ve done:

LIKE '" + po + cbIMEI.Text + po + "'

Where 'po' is a global string variable that contain the text '%'

Hope this Help.

Posted 5-Jul-10 5:15am

BoBPower17

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Martin Jarvis · Accepted Answer · 2010-07-04T14:25:00

Solution 1

Single quotes around the LIKE paramater?

LIKE '%FBKEHKEIKFFKEHKFAKEIKEJKEI%'

Posted 4-Jul-10 14:25pm

Martin Jarvis