My problem is the last bit of coding below, the like statement does not
work. what I have is a product options field and in it is stored characters
i.e. "avcy" etc what the query does is that if I type in any single
character all the products that match the criteria should be displayed. So
if I typed in an "a" I should get 3 returns (see below) Fields could look
like this:
product.options :
bhw
djhsa
ha
da
so out of the 4 products I would get 3 returns
This is the coding that I am using:
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price, [images_add]+[product_code]+'.gif' AS
images, '" & Request.QuerySt ring("find") & "' AS byprodcat,
Products.option s, Products.detail ed_desc, Products.dont_e ngrave FROM
Products, Extras WHERE (((Products.pri ce)<10) AND (('" &
Request.QuerySt ring("find") & "')='1')) OR (((Products.pri ce)>10 And
(Products.price )<20) AND (('" & Request.QuerySt ring("find") & "')='2')) OR
(((Products.pri ce)>20 And (Products.price )<30) AND (('" &
Request.QuerySt ring("find") & "')='3')) OR (((Products.pri ce)>30) AND (('" &
Request.QuerySt ring("find") & "')='4')) OR (((Products.don t_engrave)='" &
Request.QuerySt ring("find") & "')) OR (((Products.[pict category])='" &
Request.QuerySt ring("find") & "')) OR (((Products.pro duct_code)='" &
Request.QuerySt ring("find") & "')) OR (((Products.opt ions) Like '*' & '" &
Request.QuerySt ring("find") & "' & '*')) ORDER BY Products.price "
This is what access would generate, and then I have to change the coding to
make it work (see above)
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price, [images_add]+[product_code]+"".gif""
AS images, " & Request.QuerySt ring("[find]") & " AS byprodcat,
Products.option s, Products.detail ed_desc, Products.dont_e ngrave FROM
Products, Extras WHERE (((Products.pri ce)<10) AND ((" &
Request.QuerySt ring("[find]") & ")=""1"")) OR (((Products.pri ce)>10 And
(Products.price )<20) AND ((" & Request.QuerySt ring("[find]") & ")=""2"")) OR
(((Products.pri ce)>20 And (Products.price )<30) AND ((" &
Request.QuerySt ring("[find]") & ")=""3"")) OR (((Products.pri ce)>30) AND (("
& Request.QuerySt ring("[find]") & ")=""4"")) OR (((Products.don t_engrave)="
& Request.QuerySt ring("[find]") & ")) OR (((Products.[pict category])=" &
Request.QuerySt ring("[find]") & ")) OR (((Products.pro duct_code)=" &
Request.QuerySt ring("[find]") & ")) OR (((Products.opt ions) Like ""*"" & " &
Request.QuerySt ring("[find]") & " & ""*"")) ORDER BY Products.price "
9  4634 
I'm having trouble understanding Request.Queryst ring("find")
Is this a UDF? I think changing the call to Request.Queryst ring('find')
might help.
Bob Q
"Peter" <pe******@hotma il.com> wrote in
news:bp******** *@titan.btinter net.com: My problem is the last bit of coding below, the like statement does
not work. what I have is a product options field and in it is stored
characters i.e. "avcy" etc what the query does is that if I type
in any single character all the products that match the criteria
should be displayed. So if I typed in an "a" I should get 3 returns
(see below) Fields could look like this:
product.options :
bhw
djhsa
ha
da
so out of the 4 products I would get 3 returns
This is the coding that I am using:
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price,
[images_add]+[product_code]+'.gif' AS images, '" &
Request.QuerySt ring("find") & "' AS byprodcat, Products.option s,
Products.detail ed_desc, Products.dont_e ngrave FROM Products, Extras
WHERE (((Products.pri ce)<10) AND (('" & Request.QuerySt ring("find") &
"')='1')) OR (((Products.pri ce)>10 And (Products.price )<20) AND (('" &
Request.QuerySt ring("find") & "')='2')) OR (((Products.pri ce)>20 And
(Products.price )<30) AND (('" & Request.QuerySt ring("find") &
"')='3')) OR (((Products.pri ce)>30) AND (('" &
Request.QuerySt ring("find") & "')='4')) OR
(((Products.don t_engrave)='" & Request.QuerySt ring("find") & "')) OR
(((Products.[pict category])='" & Request.QuerySt ring("find") & "'))
OR (((Products.pro duct_code)='" & Request.QuerySt ring("find") & "'))
OR (((Products.opt ions) Like '*' & '" & Request.QuerySt ring("find") &
"' & '*')) ORDER BY Products.price "
This is what access would generate, and then I have to change the
coding to make it work (see above)
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price,
[images_add]+[product_code]+"".gif"" AS images, " &
Request.QuerySt ring("[find]") & " AS byprodcat, Products.option s,
Products.detail ed_desc, Products.dont_e ngrave FROM Products, Extras
WHERE (((Products.pri ce)<10) AND ((" & Request.QuerySt ring("[find]") &
")=""1"")) OR (((Products.pri ce)>10 And (Products.price )<20) AND ((" &
Request.QuerySt ring("[find]") & ")=""2"")) OR (((Products.pri ce)>20
And (Products.price )<30) AND ((" & Request.QuerySt ring("[find]") &
")=""3"")) OR (((Products.pri ce)>30) AND ((" &
Request.QuerySt ring("[find]") & ")=""4"")) OR
(((Products.don t_engrave)=" & Request.QuerySt ring("[find]") & ")) OR
(((Products.[pict category])=" & Request.QuerySt ring("[find]") & "))
OR (((Products.pro duct_code)=" & Request.QuerySt ring("[find]") & "))
OR (((Products.opt ions) Like ""*"" & " & Request.QuerySt ring("[find]")
& " & ""*"")) ORDER BY Products.price "
Hi Bob
The problem in changing the cell from a like, is that I need to search that
cell because the character I am looking for could be anywhere in that cell
i.e.
I want to find a "a" characters is a cell "kfjnbateq"
a like command would find that
Peter
"Bob Quintal" <Rq******@pants .sympatico.ca> wrote in message
news:26******** *************** *******@news.te ranews.com... I'm having trouble understanding Request.Queryst ring("find")
Is this a UDF? I think changing the call to Request.Queryst ring('find')
might help.
Bob Q
"Peter" <pe******@hotma il.com> wrote in
news:bp******** *@titan.btinter net.com:
My problem is the last bit of coding below, the like statement does
not work. what I have is a product options field and in it is stored
characters i.e. "avcy" etc what the query does is that if I type
in any single character all the products that match the criteria
should be displayed. So if I typed in an "a" I should get 3 returns
(see below) Fields could look like this:
product.options :
bhw
djhsa
ha
da
so out of the 4 products I would get 3 returns
This is the coding that I am using:
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price,
[images_add]+[product_code]+'.gif' AS images, '" &
Request.QuerySt ring("find") & "' AS byprodcat, Products.option s,
Products.detail ed_desc, Products.dont_e ngrave FROM Products, Extras
WHERE (((Products.pri ce)<10) AND (('" & Request.QuerySt ring("find") &
"')='1')) OR (((Products.pri ce)>10 And (Products.price )<20) AND (('" &
Request.QuerySt ring("find") & "')='2')) OR (((Products.pri ce)>20 And
(Products.price )<30) AND (('" & Request.QuerySt ring("find") &
"')='3')) OR (((Products.pri ce)>30) AND (('" &
Request.QuerySt ring("find") & "')='4')) OR
(((Products.don t_engrave)='" & Request.QuerySt ring("find") & "')) OR
(((Products.[pict category])='" & Request.QuerySt ring("find") & "'))
OR (((Products.pro duct_code)='" & Request.QuerySt ring("find") & "'))
OR (((Products.opt ions) Like '*' & '" & Request.QuerySt ring("find") &
"' & '*')) ORDER BY Products.price "
This is what access would generate, and then I have to change the
coding to make it work (see above)
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price,
[images_add]+[product_code]+"".gif"" AS images, " &
Request.QuerySt ring("[find]") & " AS byprodcat, Products.option s,
Products.detail ed_desc, Products.dont_e ngrave FROM Products, Extras
WHERE (((Products.pri ce)<10) AND ((" & Request.QuerySt ring("[find]") &
")=""1"")) OR (((Products.pri ce)>10 And (Products.price )<20) AND ((" &
Request.QuerySt ring("[find]") & ")=""2"")) OR (((Products.pri ce)>20
And (Products.price )<30) AND ((" & Request.QuerySt ring("[find]") &
")=""3"")) OR (((Products.pri ce)>30) AND ((" &
Request.QuerySt ring("[find]") & ")=""4"")) OR
(((Products.don t_engrave)=" & Request.QuerySt ring("[find]") & ")) OR
(((Products.[pict category])=" & Request.QuerySt ring("[find]") & "))
OR (((Products.pro duct_code)=" & Request.QuerySt ring("[find]") & "))
OR (((Products.opt ions) Like ""*"" & " & Request.QuerySt ring("[find]")
& " & ""*"")) ORDER BY Products.price "
"Peter" <pe******@hotma il.com> wrote in
news:bp******** **@titan.btinte rnet.com: Hi Bob
The problem in changing the cell from a like, is that I need to search
that cell because the character I am looking for could be anywhere in
that cell i.e.
I want to find a "a" characters is a cell "kfjnbateq"
a like command would find that
Peter
I'm not saying not to use like, but to diagnose your problem, I have to
figure out what Request.queryst ring() is and does., and what "find" is
and does.
OR Products.option s Like
""*"" & " & Request.QuerySt ring("[find]") & " & ""*""))
Is not acceptable use of quotes
LIKE '*'" & request.queryst ring('find') & "'*'" might be, but it still
seems wrong to me. I need to know about Request.Queryst ring()
This
Bob
"Bob Quintal" <Rq******@pants .sympatico.ca> wrote in message
news:26******** *************** *******@news.te ranews.com... I'm having trouble understanding Request.Queryst ring("find")
Is this a UDF? I think changing the call to
Request.Queryst ring('find') might help.
Bob Q
"Peter" <pe******@hotma il.com> wrote in
news:bp******** *@titan.btinter net.com:
> My problem is the last bit of coding below, the like statement
> does not work. what I have is a product options field and in it is
> stored characters i.e. "avcy" etc what the query does is that
> if I type in any single character all the products that match the
> criteria should be displayed. So if I typed in an "a" I should get
> 3 returns (see below) Fields could look like this:
>
> product.options :
> bhw
> djhsa
> ha
> da
>
> so out of the 4 products I would get 3 returns
>
> This is the coding that I am using:
>
> sql = "SELECT Products.[pict category], Products.produc t_code,
> Products.descri ption, Products.price,
> [images_add]+[product_code]+'.gif' AS images, '" &
> Request.QuerySt ring("find") & "' AS byprodcat, Products.option s,
> Products.detail ed_desc, Products.dont_e ngrave FROM Products,
> Extras WHERE (((Products.pri ce)<10) AND (('" &
> Request.QuerySt ring("find") & "')='1')) OR (((Products.pri ce)>10
> And (Products.price )<20) AND (('" & Request.QuerySt ring("find") &
> "')='2')) OR (((Products.pri ce)>20 And (Products.price )<30) AND
> (('" & Request.QuerySt ring("find") & "')='3')) OR
> (((Products.pri ce)>30) AND (('" & Request.QuerySt ring("find") &
> "')='4')) OR (((Products.don t_engrave)='" &
> Request.QuerySt ring("find") & "')) OR (((Products.[pict
> category])='" & Request.QuerySt ring("find") & "')) OR
> (((Products.pro duct_code)='" & Request.QuerySt ring("find") & "'))
> OR (((Products.opt ions) Like '*' & '" & Request.QuerySt ring("find")
> & "' & '*')) ORDER BY Products.price "
>
>
> This is what access would generate, and then I have to change the
> coding to make it work (see above)
>
> sql = "SELECT Products.[pict category], Products.produc t_code,
> Products.descri ption, Products.price,
> [images_add]+[product_code]+"".gif"" AS images, " &
> Request.QuerySt ring("[find]") & " AS byprodcat, Products.option s,
> Products.detail ed_desc, Products.dont_e ngrave FROM Products,
> Extras WHERE (((Products.pri ce)<10) AND ((" &
> Request.QuerySt ring("[find]") & ")=""1"")) OR (((Products.pri ce)>10
> And (Products.price )<20) AND ((" & Request.QuerySt ring("[find]") &
> ")=""2"")) OR (((Products.pri ce)>20 And (Products.price )<30) AND
> ((" & Request.QuerySt ring("[find]") & ")=""3"")) OR
> (((Products.pri ce)>30) AND ((" & Request.QuerySt ring("[find]") &
> ")=""4"")) OR (((Products.don t_engrave)=" &
> Request.QuerySt ring("[find]") & ")) OR (((Products.[pict
> category])=" & Request.QuerySt ring("[find]") & ")) OR
> (((Products.pro duct_code)=" & Request.QuerySt ring("[find]") & "))
> OR (((Products.opt ions) Like ""*"" & " &
> Request.QuerySt ring("[find]") & " & ""*"")) ORDER BY
> Products.price "
>
>
>
>
Bob
The whole thing seams so strange at the very bottom of this message is the
code that Access generates, them to make is work on the server I have to
mess around by putting in single quotes and string out square brackets. If
I take out the kind statement it works fine.
All I want to do is to get a wide card statement i.e. find a single
character in a string
Bob is there anything I can send you to help me solve the problem
Peter
"Bob Quintal" <Rq******@pants .sympatico.ca> wrote in message
news:ce******** *************** *******@news.te ranews.com... "Peter" <pe******@hotma il.com> wrote in
news:bp******** **@titan.btinte rnet.com:
Hi Bob
The problem in changing the cell from a like, is that I need to search
that cell because the character I am looking for could be anywhere in
that cell i.e.
I want to find a "a" characters is a cell "kfjnbateq"
a like command would find that
Peter
I'm not saying not to use like, but to diagnose your problem, I have to
figure out what Request.queryst ring() is and does., and what "find" is
and does.
OR Products.option s Like
""*"" & " & Request.QuerySt ring("[find]") & " & ""*""))
Is not acceptable use of quotes
LIKE '*'" & request.queryst ring('find') & "'*'" might be, but it still
seems wrong to me. I need to know about Request.Queryst ring()
This
Bob
"Bob Quintal" <Rq******@pants .sympatico.ca> wrote in message
news:26******** *************** *******@news.te ranews.com... I'm having trouble understanding Request.Queryst ring("find")
Is this a UDF? I think changing the call to
Request.Queryst ring('find') might help.
Bob Q
"Peter" <pe******@hotma il.com> wrote in
news:bp******** *@titan.btinter net.com:
> My problem is the last bit of coding below, the like statement
> does not work. what I have is a product options field and in it is
> stored characters i.e. "avcy" etc what the query does is that
> if I type in any single character all the products that match the
> criteria should be displayed. So if I typed in an "a" I should get
> 3 returns (see below) Fields could look like this:
>
> product.options :
> bhw
> djhsa
> ha
> da
>
> so out of the 4 products I would get 3 returns
>
> This is the coding that I am using:
>
> sql = "SELECT Products.[pict category], Products.produc t_code,
> Products.descri ption, Products.price,
> [images_add]+[product_code]+'.gif' AS images, '" &
> Request.QuerySt ring("find") & "' AS byprodcat, Products.option s,
> Products.detail ed_desc, Products.dont_e ngrave FROM Products,
> Extras WHERE (((Products.pri ce)<10) AND (('" &
> Request.QuerySt ring("find") & "')='1')) OR (((Products.pri ce)>10
> And (Products.price )<20) AND (('" & Request.QuerySt ring("find") &
> "')='2')) OR (((Products.pri ce)>20 And (Products.price )<30) AND
> (('" & Request.QuerySt ring("find") & "')='3')) OR
> (((Products.pri ce)>30) AND (('" & Request.QuerySt ring("find") &
> "')='4')) OR (((Products.don t_engrave)='" &
> Request.QuerySt ring("find") & "')) OR (((Products.[pict
> category])='" & Request.QuerySt ring("find") & "')) OR
> (((Products.pro duct_code)='" & Request.QuerySt ring("find") & "'))
> OR (((Products.opt ions) Like '*' & '" & Request.QuerySt ring("find")
> & "' & '*')) ORDER BY Products.price "
>
>
> This is what access would generate, and then I have to change the
> coding to make it work (see above)
>
> sql = "SELECT Products.[pict category], Products.produc t_code,
> Products.descri ption, Products.price,
> [images_add]+[product_code]+"".gif"" AS images, " &
> Request.QuerySt ring("[find]") & " AS byprodcat, Products.option s,
> Products.detail ed_desc, Products.dont_e ngrave FROM Products,
> Extras WHERE (((Products.pri ce)<10) AND ((" &
> Request.QuerySt ring("[find]") & ")=""1"")) OR (((Products.pri ce)>10
> And (Products.price )<20) AND ((" & Request.QuerySt ring("[find]") &
> ")=""2"")) OR (((Products.pri ce)>20 And (Products.price )<30) AND
> ((" & Request.QuerySt ring("[find]") & ")=""3"")) OR
> (((Products.pri ce)>30) AND ((" & Request.QuerySt ring("[find]") &
> ")=""4"")) OR (((Products.don t_engrave)=" &
> Request.QuerySt ring("[find]") & ")) OR (((Products.[pict
> category])=" & Request.QuerySt ring("[find]") & ")) OR
> (((Products.pro duct_code)=" & Request.QuerySt ring("[find]") & "))
> OR (((Products.opt ions) Like ""*"" & " &
> Request.QuerySt ring("[find]") & " & ""*"")) ORDER BY
> Products.price "
>
>
>
>
"Peter" <pe******@hotma il.com> wrote in
news:bp******** **@hercules.bti nternet.com: Bob
Bob is there anything I can send you to help me solve the problem
Yes there is. It's an explanation of Request.Queryst ring. Whyat is
Request.Queryst ring?
Bob
Peter
"Bob Quintal" <Rq******@pants .sympatico.ca> wrote in message
news:ce******** *************** *******@news.te ranews.com... "Peter" <pe******@hotma il.com> wrote in
news:bp******** **@titan.btinte rnet.com:
> Hi Bob
> The problem in changing the cell from a like, is that I need to
> search that cell because the character I am looking for could be
> anywhere in that cell i.e.
>
> I want to find a "a" characters is a cell "kfjnbateq"
> a like command would find that
>
> Peter
>
I'm not saying not to use like, but to diagnose your problem, I have
to figure out what Request.queryst ring() is and does., and what
"find" is and does.
OR Products.option s Like
""*"" & " & Request.QuerySt ring("[find]") & " & ""*""))
Is not acceptable use of quotes
LIKE '*'" & request.queryst ring('find') & "'*'" might be, but it
still seems wrong to me. I need to know about Request.Queryst ring()
This
Bob
>
> "Bob Quintal" <Rq******@pants .sympatico.ca> wrote in message
> news:26******** *************** *******@news.te ranews.com...
>> I'm having trouble understanding Request.Queryst ring("find")
>> Is this a UDF? I think changing the call to
>> Request.Queryst ring('find') might help.
>>
>>
>> Bob Q
>>
>>
>> "Peter" <pe******@hotma il.com> wrote in
>> news:bp******** *@titan.btinter net.com:
>>
>> > My problem is the last bit of coding below, the like statement
>> > does not work. what I have is a product options field and in it
>> > is stored characters i.e. "avcy" etc what the query does is
>> > that if I type in any single character all the products that
>> > match the criteria should be displayed. So if I typed in an "a"
>> > I should get 3 returns (see below) Fields could look like this:
>> >
>> > product.options :
>> > bhw
>> > djhsa
>> > ha
>> > da
>> >
>> > so out of the 4 products I would get 3 returns
>> >
>> > This is the coding that I am using:
>> >
>> > sql = "SELECT Products.[pict category], Products.produc t_code,
>> > Products.descri ption, Products.price,
>> > [images_add]+[product_code]+'.gif' AS images, '" &
>> > Request.QuerySt ring("find") & "' AS byprodcat, Products.option s,
>> > Products.detail ed_desc, Products.dont_e ngrave FROM Products,
>> > Extras WHERE (((Products.pri ce)<10) AND (('" &
>> > Request.QuerySt ring("find") & "')='1')) OR (((Products.pri ce)>10
>> > And (Products.price )<20) AND (('" & Request.QuerySt ring("find")
>> > & "')='2')) OR (((Products.pri ce)>20 And (Products.price )<30)
>> > AND (('" & Request.QuerySt ring("find") & "')='3')) OR
>> > (((Products.pri ce)>30) AND (('" & Request.QuerySt ring("find") &
>> > "')='4')) OR (((Products.don t_engrave)='" &
>> > Request.QuerySt ring("find") & "')) OR (((Products.[pict
>> > category])='" & Request.QuerySt ring("find") & "')) OR
>> > (((Products.pro duct_code)='" & Request.QuerySt ring("find") &
>> > "')) OR (((Products.opt ions) Like '*' & '" &
>> > Request.QuerySt ring("find") & "' & '*')) ORDER BY
>> > Products.price "
>> >
>> >
>> > This is what access would generate, and then I have to change
>> > the coding to make it work (see above)
>> >
>> > sql = "SELECT Products.[pict category],
>> > Products.produc t_code,
>> > Products.descri ption, Products.price,
>> > [images_add]+[product_code]+"".gif"" AS images, " &
>> > Request.QuerySt ring("[find]") & " AS byprodcat,
>> > Products.option s, Products.detail ed_desc, Products.dont_e ngrave
>> > FROM Products, Extras WHERE (((Products.pri ce)<10) AND ((" &
>> > Request.QuerySt ring("[find]") & ")=""1"")) OR
>> > (((Products.pri ce)>10 And (Products.price )<20) AND ((" &
>> > Request.QuerySt ring("[find]") & ")=""2"")) OR
>> > (((Products.pri ce)>20 And (Products.price )<30) AND ((" &
>> > Request.QuerySt ring("[find]") & ")=""3"")) OR
>> > (((Products.pri ce)>30) AND ((" & Request.QuerySt ring("[find]") &
>> > ")=""4"")) OR (((Products.don t_engrave)=" &
>> > Request.QuerySt ring("[find]") & ")) OR (((Products.[pict
>> > category])=" & Request.QuerySt ring("[find]") & ")) OR
>> > (((Products.pro duct_code)=" & Request.QuerySt ring("[find]") &
>> > ")) OR (((Products.opt ions) Like ""*"" & " &
>> > Request.QuerySt ring("[find]") & " & ""*"")) ORDER BY
>> > Products.price "
>> >
>> >
>> >
>> >
>>
>
>
>
On Mon, 24 Nov 2003 01:27:11 GMT in comp.databases. ms-access, Bob
Quintal <Rq******@pants .sympatico.ca> wrote: "Peter" <pe******@hotma il.com> wrote in
news:bp******* ***@hercules.bt internet.com:
Bob
Bob is there anything I can send you to help me solve the problem
Yes there is. It's an explanation of Request.Queryst ring. Whyat is
Request.Querys tring?
ASP.
On the page www.mysite.com/mypage.asp?blah
would return "blah"
--
A)bort, R)etry, I)nfluence with large hammer.
On Sun, 23 Nov 2003 22:55:33 +0000 (UTC) in comp.databases. ms-access,
"Peter" <pe******@hotma il.com> wrote: Bob
The whole thing seams so strange at the very bottom of this message is the
code that Access generates, them to make is work on the server I have to
mess around by putting in single quotes and string out square brackets. If
I take out the kind statement it works fine.
All I want to do is to get a wide card statement i.e. find a single
character in a string
Try using "%" instead of "*".
--
A)bort, R)etry, I)nfluence with large hammer.
Trevor
IT WORKED
Thank you very much to you Trevor and Bob for helping me out Thanks
Peter
"Trevor Best" <bouncer@localh ost> wrote in message
news:ip******** *************** *********@4ax.c om... On Sun, 23 Nov 2003 22:55:33 +0000 (UTC) in comp.databases. ms-access,
"Peter" <pe******@hotma il.com> wrote:
Bob
The whole thing seams so strange at the very bottom of this message is
thecode that Access generates, them to make is work on the server I have to
mess around by putting in single quotes and string out square brackets.
IfI take out the kind statement it works fine.
All I want to do is to get a wide card statement i.e. find a single
character in a string
Try using "%" instead of "*".
--
A)bort, R)etry, I)nfluence with large hammer.
Guys can I take this one step further, the like command below, can I make
that case sensitive ???
Like '%' & '" & Request.QuerySt ring("find") & "' & '%')) ORDER BY
Products.price "
Peter
sql = "SELECT Products.[pict category], Products.produc t_code,
Products.descri ption, Products.price, '" & Request.QuerySt ring("find") & "'
AS byprodcat, Products.option s, Products.detail ed_desc,
Products.dont_e ngrave FROM Products WHERE (((Products.pri ce)<10) AND (('"
& Request.QuerySt ring("find") & "')='1')) OR (((Products.pri ce)>10 And
(Products.price )<20) AND (('" & Request.QuerySt ring("find") & "')='2')) OR
(((Products.pri ce)>20 And (Products.price )<30) AND (('" &
Request.QuerySt ring("find") & "')='3')) OR (((Products.pri ce)>30) AND (('" &
Request.QuerySt ring("find") & "')='4')) OR (((Products.don t_engrave)='" &
Request.QuerySt ring("find") & "')) OR (((Products.[pict category])='" &
Request.QuerySt ring("find") & "')) OR (((Products.pro duct_code)='" &
Request.QuerySt ring("find") & "')) OR (((Products.opt ions) Like '%' & '" &
Request.QuerySt ring("find") & "' & '%')) ORDER BY Products.price "
"Peter" <pe******@hotma il.com> wrote in message
news:bp******** **@sparta.btint ernet.com... Trevor
IT WORKED
Thank you very much to you Trevor and Bob for helping me out Thanks
Peter
"Trevor Best" <bouncer@localh ost> wrote in message
news:ip******** *************** *********@4ax.c om... On Sun, 23 Nov 2003 22:55:33 +0000 (UTC) in comp.databases. ms-access,
"Peter" <pe******@hotma il.com> wrote:
Bob
The whole thing seams so strange at the very bottom of this message is thecode that Access generates, them to make is work on the server I have
tomess around by putting in single quotes and string out square brackets. IfI take out the kind statement it works fine.
All I want to do is to get a wide card statement i.e. find a single
character in a string
Try using "%" instead of "*".
--
A)bort, R)etry, I)nfluence with large hammer.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Radioactive Man |
last post by:
anyone know of a function like "raw_input", which collects a string
from the user entry, but one where I can set a time limit, as follows:
time_limit = 10 # seconds
user_answer = function_xyz("GIVE ME AN ANSWER: ", time_limit)
The problem with "raw_input" is that it will stop unattended script
indefinitely. I'm looking for a function that does the exact same
thing, but with a time limit feature, and preferably one that returns
|
by: coryjflynn |
last post by:
I am try to update the Gender field for all females of a database with
about 15,000 records. So how I started was by searching baby girl
names on the web and manipulated some of there lists to create my own
table of female first names (HSNames). I can then use this table to
update the Gender field to 'F' (female) in the master table. This
process works great using the following query...
Update HSContacts
Set Gender = 'F'
Where...
|
by: Big John |
last post by:
in Access 2003 I am trying to get sql query to run using a field as
input, but I want to input into the field a value that uses the "like"
operator to find any value that starts with the value placed in the
field.
e.g if i place the text "ada" in the field i want all values with
"ada???????" when the sql is run. I can do it in a query by placing the
value in a like statement and it gives all variations , but i want the
value to be a...
|
by: S. van Beek |
last post by:
Dear reader,
How can I filter a numeric field with Like as criteria in a query.
To filter a numeric field with <10 as criteria this will com back with the
result of those records for which the value is smaller as teen.
But in case this value is variable and you prefer to work with "Like
|
by: Derrick |
last post by:
Is there a C# "Like" statement for comparing two strings?
if(stringA Like "%diabe%mel%)
do stuff...
Thanks in advance!
Derrick
| | |
by: Craig Kenisston |
last post by:
Hi,
I need to write a function that should behave like the SQL's "like" operator
on a list of words.
I was wondering if I can use Regex directly to do this job. But I've been
reading about regex and it supports very different characters and behaves
different.
So, I'm looking for an advise. I'd like to know if it is feasable or not, I
mean, if dotnet Regex implementation could handle it.
|
by: Risen |
last post by:
Hi,all,
I want to execute SQL command " DROP DATABASE mydb" and "Restore DATABASE
....." in vb.net 2003. But it always shows error. If any body can tell me how
to execute sql command as above? Thanks a lot.
Best regard.
Risen
|
by: samjnaa |
last post by:
Please check for sanity and approve for posting at python-dev.
In Visual Basic there is the keyword "with" which allows an object-
name to be declared as governing the following statements. For
example:
with quitCommandButton
.enabled = true
.default = true
end with
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
