Solved

TSQL Delphi query get parameter error when where containing " and % BOTH characters

Posted on 2014-04-14
6
520 Views
Last Modified: 2014-04-14
select * from table_name where colname like ('%" :%')

getting error : no value for parameter '%')

paramcheck is disabled, but not helps
0
Comment
Question by:RT_
  • 3
  • 3
6 Comments
 
LVL 33

Expert Comment

by:ste5an
ID: 39998806
What chars are you looking for? How does the condition looks like in SSMS?

Keep in mind that ' and " need to be escaped. E.g.

Condition := 'WHERE colname LIKE ''%:%''';

Open in new window

0
 

Author Comment

by:RT_
ID: 39999139
here are the string, that i am searcing for :

ACER monitor AL1512 15" 1024*768, 400:1 kontrasztarány, 350cd/m2 - használt

but on insert statement, the problem is the same.

When i'll cut the " or the :  chars, the query is working.

The database is on Mysql.
0
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 39999278
Yup, the single quotation mark is the Pascal string delimiter and the colon is the indicator for a parameter (haven't seen this either in your first post).

The single quotation mark must be doubled to be escaped. The colon needs that you set it by a string variable:

SqlStatement := 'SELECT * FROM table_name WHERE colname LIKE ( ''%":%'');';
AdoDataSet.ParamCheck := False;
AdoDataSet.CommandText := SqlStatement;
AdoDataSet..Open;

Open in new window


The order of ParamChek and the CommandText assignement is necessary to make it work.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:RT_
ID: 39999307
here is the exact code, the double quotation is there but, still the no value for parameter 1


f_DataModule.MSHQms_fotabla_v.SQL.Text := 'select * from ms_raktar where megjegyzes like (''%ACER monitor AL1512 15" 1024*768, 400:1 kontrasztarány, 350cd/m2 - használt%'');';

f_DataModule.MSHQms_fotabla_v.ParamCheck := False;
f_DataModule.MSHQms_fotabla_v.Open;
0
 
LVL 33

Expert Comment

by:ste5an
ID: 39999597
No, take a look at my sample again.

f_DataModule.MSHQms_fotabla_v.Close; // Just in case that not.
f_DataModule.MSHQms_fotabla_v.SQL.Clear;
f_DataModule.MSHQms_fotabla_v.ParamCheck := False;
f_DataModule.MSHQms_fotabla_v.SQL.Text := 'select * from ms_raktar where megjegyzes like (''%ACER monitor AL1512 15" 1024*768, 400:1 kontrasztarány, 350cd/m2 - használt%'');';
f_DataModule.MSHQms_fotabla_v.Open;

Open in new window

0
 

Author Closing Comment

by:RT_
ID: 39999845
Thanks a lot, i have found the difference and now it works!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Bartender Integration Builder 3 62
AvlTree-Node Data type 4 22
Problems moving Excel files from local drive to server 4 25
CSV file copy field 1 to field 2 2 35
The purpose of this article is to demonstrate how we can use conditional statements using Python.
A short article about problems I had with the new location API and permissions in Marshmallow
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question