like statment

Fary4u

Hi

i'm trying to search the value in my following field. i don't know why it's giving me this error

Expand|Select|Wrap|Line Numbers

 
select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%"&styno&"%'") ")

without wildcard it's works fine but wd wildcard gives error
Unterminated string constant. ?

Fary4u

yes sorted but executed query but no result found ?

Expand|Select|Wrap|Line Numbers

 select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%" & styno & "%') ")
 
 

still can't find the styno value

Atli

Hi.

Can you show us what the query looks like after you construct it?

Meaning:

Expand|Select|Wrap|Line Numbers

 
Dim colValue As String = "someValue"

Dim sql As String = "SELECT * FROM myTbl WHERE col = '" & colValue & "'"
 
Response.Write(sql) ' What would this show you?

Fary4u

Hi thanks for ur reply

the problem is not in query anymore it's bring the result but it's not searching value in the variable but variable values passing parameters ? ? ? ?

i'm very much confused wht's going on ? ? ?

my DB Values like this

Expand|Select|Wrap|Line Numbers

 
CatalogID  |  productDess

1  |  x / y / z

2  |  A / B / C

3  |  1 / 2 / 3

result should b like this

Expand|Select|Wrap|Line Numbers

(CatalogID='2') AND (productDescc like '%B%')

coding

Expand|Select|Wrap|Line Numbers

 
select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%" & styno & "%') ")

it's working fine & donig the same i would like to do but not returning value from " B " result

Atli

That query, executed against that data (overlooking the column name typo) should only return the second row

Quote:

Originally Posted by Fary4u

the problem is not in query anymore it's bring the result but it's not searching value in the variable but variable values passing parameters ? ? ? ?

I'm afraid I don't understand what you are saying here.
Could you try to explain this a little better?

Aside from that, there are a couple of things that you might want to look into.

Numeric values in queries should not be quoted, like your CatalogID.
It should be
Expand|Select|Wrap|Line Numbers
1. (CatalogID=2)
(Assuming CatalogID is an integer)
Your productDescc column is storing multiple values.
This violates the most basic rule of relational database design.
Each field should only contain a single value, and never a list of values.
See this article on Database Normalization and Table Structures to learn more.

like statment

re: like statment

re: like statment

re: like statment

re: like statment

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about