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.product_code,
Products.description, Products.price, [images_add]+[product_code]+'.gif' AS
images, '" & Request.QueryString("find") & "' AS byprodcat,
Products.options, Products.detailed_desc, Products.dont_engrave FROM
Products, Extras WHERE (((Products.price)<10) AND (('" &
Request.QueryString("find") & "')='1')) OR (((Products.price)>10 And
(Products.price)<20) AND (('" & Request.QueryString("find") & "')='2')) OR
(((Products.price)>20 And (Products.price)<30) AND (('" &
Request.QueryString("find") & "')='3')) OR (((Products.price)>30) AND (('" &
Request.QueryString("find") & "')='4')) OR (((Products.dont_engrave)='" &
Request.QueryString("find") & "')) OR (((Products.[pict category])='" &
Request.QueryString("find") & "')) OR (((Products.product_code)='" &
Request.QueryString("find") & "')) OR (((Products.options) Like '*' & '" &
Request.QueryString("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.product_code,
Products.description, Products.price, [images_add]+[product_code]+"".gif""
AS images, " & Request.QueryString("[find]") & " AS byprodcat,
Products.options, Products.detailed_desc, Products.dont_engrave FROM
Products, Extras WHERE (((Products.price)<10) AND ((" &
Request.QueryString("[find]") & ")=""1"")) OR (((Products.price)>10 And
(Products.price)<20) AND ((" & Request.QueryString("[find]") & ")=""2"")) OR
(((Products.price)>20 And (Products.price)<30) AND ((" &
Request.QueryString("[find]") & ")=""3"")) OR (((Products.price)>30) AND (("
& Request.QueryString("[find]") & ")=""4"")) OR (((Products.dont_engrave)="
& Request.QueryString("[find]") & ")) OR (((Products.[pict category])=" &
Request.QueryString("[find]") & ")) OR (((Products.product_code)=" &
Request.QueryString("[find]") & ")) OR (((Products.options) Like ""*"" & " &
Request.QueryString("[find]") & " & ""*"")) ORDER BY Products.price " 9 4611
I'm having trouble understanding Request.Querystring("find")
Is this a UDF? I think changing the call to Request.Querystring('find')
might help.
Bob Q
"Peter" <pe******@hotmail.com> wrote in
news:bp*********@titan.btinternet.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.product_code, Products.description, Products.price, [images_add]+[product_code]+'.gif' AS images, '" & Request.QueryString("find") & "' AS byprodcat, Products.options, Products.detailed_desc, Products.dont_engrave FROM Products, Extras WHERE (((Products.price)<10) AND (('" & Request.QueryString("find") & "')='1')) OR (((Products.price)>10 And (Products.price)<20) AND (('" & Request.QueryString("find") & "')='2')) OR (((Products.price)>20 And (Products.price)<30) AND (('" & Request.QueryString("find") & "')='3')) OR (((Products.price)>30) AND (('" & Request.QueryString("find") & "')='4')) OR (((Products.dont_engrave)='" & Request.QueryString("find") & "')) OR (((Products.[pict category])='" & Request.QueryString("find") & "')) OR (((Products.product_code)='" & Request.QueryString("find") & "')) OR (((Products.options) Like '*' & '" & Request.QueryString("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.product_code, Products.description, Products.price, [images_add]+[product_code]+"".gif"" AS images, " & Request.QueryString("[find]") & " AS byprodcat, Products.options, Products.detailed_desc, Products.dont_engrave FROM Products, Extras WHERE (((Products.price)<10) AND ((" & Request.QueryString("[find]") & ")=""1"")) OR (((Products.price)>10 And (Products.price)<20) AND ((" & Request.QueryString("[find]") & ")=""2"")) OR (((Products.price)>20 And (Products.price)<30) AND ((" & Request.QueryString("[find]") & ")=""3"")) OR (((Products.price)>30) AND ((" & Request.QueryString("[find]") & ")=""4"")) OR (((Products.dont_engrave)=" & Request.QueryString("[find]") & ")) OR (((Products.[pict category])=" & Request.QueryString("[find]") & ")) OR (((Products.product_code)=" & Request.QueryString("[find]") & ")) OR (((Products.options) Like ""*"" & " & Request.QueryString("[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.teranew s.com... I'm having trouble understanding Request.Querystring("find") Is this a UDF? I think changing the call to Request.Querystring('find') might help.
Bob Q
"Peter" <pe******@hotmail.com> wrote in news:bp*********@titan.btinternet.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.product_code, Products.description, Products.price, [images_add]+[product_code]+'.gif' AS images, '" & Request.QueryString("find") & "' AS byprodcat, Products.options, Products.detailed_desc, Products.dont_engrave FROM Products, Extras WHERE (((Products.price)<10) AND (('" & Request.QueryString("find") & "')='1')) OR (((Products.price)>10 And (Products.price)<20) AND (('" & Request.QueryString("find") & "')='2')) OR (((Products.price)>20 And (Products.price)<30) AND (('" & Request.QueryString("find") & "')='3')) OR (((Products.price)>30) AND (('" & Request.QueryString("find") & "')='4')) OR (((Products.dont_engrave)='" & Request.QueryString("find") & "')) OR (((Products.[pict category])='" & Request.QueryString("find") & "')) OR (((Products.product_code)='" & Request.QueryString("find") & "')) OR (((Products.options) Like '*' & '" & Request.QueryString("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.product_code, Products.description, Products.price, [images_add]+[product_code]+"".gif"" AS images, " & Request.QueryString("[find]") & " AS byprodcat, Products.options, Products.detailed_desc, Products.dont_engrave FROM Products, Extras WHERE (((Products.price)<10) AND ((" & Request.QueryString("[find]") & ")=""1"")) OR (((Products.price)>10 And (Products.price)<20) AND ((" & Request.QueryString("[find]") & ")=""2"")) OR (((Products.price)>20 And (Products.price)<30) AND ((" & Request.QueryString("[find]") & ")=""3"")) OR (((Products.price)>30) AND ((" & Request.QueryString("[find]") & ")=""4"")) OR (((Products.dont_engrave)=" & Request.QueryString("[find]") & ")) OR (((Products.[pict category])=" & Request.QueryString("[find]") & ")) OR (((Products.product_code)=" & Request.QueryString("[find]") & ")) OR (((Products.options) Like ""*"" & " & Request.QueryString("[find]") & " & ""*"")) ORDER BY Products.price "
"Peter" <pe******@hotmail.com> wrote in
news:bp**********@titan.btinternet.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.querystring() is and does., and what "find" is
and does.
OR Products.options Like
""*"" & " & Request.QueryString("[find]") & " & ""*""))
Is not acceptable use of quotes
LIKE '*'" & request.querystring('find') & "'*'" might be, but it still
seems wrong to me. I need to know about Request.Querystring()
This
Bob "Bob Quintal" <Rq******@pants.sympatico.ca> wrote in message news:26******************************@news.teranew s.com... I'm having trouble understanding Request.Querystring("find") Is this a UDF? I think changing the call to Request.Querystring('find') might help.
Bob Q
"Peter" <pe******@hotmail.com> wrote in news:bp*********@titan.btinternet.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.product_code, > Products.description, Products.price, > [images_add]+[product_code]+'.gif' AS images, '" & > Request.QueryString("find") & "' AS byprodcat, Products.options, > Products.detailed_desc, Products.dont_engrave FROM Products, > Extras WHERE (((Products.price)<10) AND (('" & > Request.QueryString("find") & "')='1')) OR (((Products.price)>10 > And (Products.price)<20) AND (('" & Request.QueryString("find") & > "')='2')) OR (((Products.price)>20 And (Products.price)<30) AND > (('" & Request.QueryString("find") & "')='3')) OR > (((Products.price)>30) AND (('" & Request.QueryString("find") & > "')='4')) OR (((Products.dont_engrave)='" & > Request.QueryString("find") & "')) OR (((Products.[pict > category])='" & Request.QueryString("find") & "')) OR > (((Products.product_code)='" & Request.QueryString("find") & "')) > OR (((Products.options) Like '*' & '" & Request.QueryString("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.product_code, > Products.description, Products.price, > [images_add]+[product_code]+"".gif"" AS images, " & > Request.QueryString("[find]") & " AS byprodcat, Products.options, > Products.detailed_desc, Products.dont_engrave FROM Products, > Extras WHERE (((Products.price)<10) AND ((" & > Request.QueryString("[find]") & ")=""1"")) OR (((Products.price)>10 > And (Products.price)<20) AND ((" & Request.QueryString("[find]") & > ")=""2"")) OR (((Products.price)>20 And (Products.price)<30) AND > ((" & Request.QueryString("[find]") & ")=""3"")) OR > (((Products.price)>30) AND ((" & Request.QueryString("[find]") & > ")=""4"")) OR (((Products.dont_engrave)=" & > Request.QueryString("[find]") & ")) OR (((Products.[pict > category])=" & Request.QueryString("[find]") & ")) OR > (((Products.product_code)=" & Request.QueryString("[find]") & ")) > OR (((Products.options) Like ""*"" & " & > Request.QueryString("[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.teranew s.com... "Peter" <pe******@hotmail.com> wrote in news:bp**********@titan.btinternet.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.querystring() is and does., and what "find" is and does.
OR Products.options Like ""*"" & " & Request.QueryString("[find]") & " & ""*"")) Is not acceptable use of quotes LIKE '*'" & request.querystring('find') & "'*'" might be, but it still seems wrong to me. I need to know about Request.Querystring()
This Bob
"Bob Quintal" <Rq******@pants.sympatico.ca> wrote in message news:26******************************@news.teranew s.com... I'm having trouble understanding Request.Querystring("find") Is this a UDF? I think changing the call to Request.Querystring('find') might help.
Bob Q
"Peter" <pe******@hotmail.com> wrote in news:bp*********@titan.btinternet.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.product_code, > Products.description, Products.price, > [images_add]+[product_code]+'.gif' AS images, '" & > Request.QueryString("find") & "' AS byprodcat, Products.options, > Products.detailed_desc, Products.dont_engrave FROM Products, > Extras WHERE (((Products.price)<10) AND (('" & > Request.QueryString("find") & "')='1')) OR (((Products.price)>10 > And (Products.price)<20) AND (('" & Request.QueryString("find") & > "')='2')) OR (((Products.price)>20 And (Products.price)<30) AND > (('" & Request.QueryString("find") & "')='3')) OR > (((Products.price)>30) AND (('" & Request.QueryString("find") & > "')='4')) OR (((Products.dont_engrave)='" & > Request.QueryString("find") & "')) OR (((Products.[pict > category])='" & Request.QueryString("find") & "')) OR > (((Products.product_code)='" & Request.QueryString("find") & "')) > OR (((Products.options) Like '*' & '" & Request.QueryString("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.product_code, > Products.description, Products.price, > [images_add]+[product_code]+"".gif"" AS images, " & > Request.QueryString("[find]") & " AS byprodcat, Products.options, > Products.detailed_desc, Products.dont_engrave FROM Products, > Extras WHERE (((Products.price)<10) AND ((" & > Request.QueryString("[find]") & ")=""1"")) OR (((Products.price)>10 > And (Products.price)<20) AND ((" & Request.QueryString("[find]") & > ")=""2"")) OR (((Products.price)>20 And (Products.price)<30) AND > ((" & Request.QueryString("[find]") & ")=""3"")) OR > (((Products.price)>30) AND ((" & Request.QueryString("[find]") & > ")=""4"")) OR (((Products.dont_engrave)=" & > Request.QueryString("[find]") & ")) OR (((Products.[pict > category])=" & Request.QueryString("[find]") & ")) OR > (((Products.product_code)=" & Request.QueryString("[find]") & ")) > OR (((Products.options) Like ""*"" & " & > Request.QueryString("[find]") & " & ""*"")) ORDER BY > Products.price " > > > >
"Peter" <pe******@hotmail.com> wrote in
news:bp**********@hercules.btinternet.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.Querystring. Whyat is
Request.Querystring?
Bob
Peter
"Bob Quintal" <Rq******@pants.sympatico.ca> wrote in message news:ce******************************@news.teranew s.com... "Peter" <pe******@hotmail.com> wrote in news:bp**********@titan.btinternet.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.querystring() is and does., and what "find" is and does.
OR Products.options Like ""*"" & " & Request.QueryString("[find]") & " & ""*"")) Is not acceptable use of quotes LIKE '*'" & request.querystring('find') & "'*'" might be, but it still seems wrong to me. I need to know about Request.Querystring()
This Bob
> > "Bob Quintal" <Rq******@pants.sympatico.ca> wrote in message > news:26******************************@news.teranew s.com... >> I'm having trouble understanding Request.Querystring("find") >> Is this a UDF? I think changing the call to >> Request.Querystring('find') might help. >> >> >> Bob Q >> >> >> "Peter" <pe******@hotmail.com> wrote in >> news:bp*********@titan.btinternet.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.product_code, >> > Products.description, Products.price, >> > [images_add]+[product_code]+'.gif' AS images, '" & >> > Request.QueryString("find") & "' AS byprodcat, Products.options, >> > Products.detailed_desc, Products.dont_engrave FROM Products, >> > Extras WHERE (((Products.price)<10) AND (('" & >> > Request.QueryString("find") & "')='1')) OR (((Products.price)>10 >> > And (Products.price)<20) AND (('" & Request.QueryString("find") >> > & "')='2')) OR (((Products.price)>20 And (Products.price)<30) >> > AND (('" & Request.QueryString("find") & "')='3')) OR >> > (((Products.price)>30) AND (('" & Request.QueryString("find") & >> > "')='4')) OR (((Products.dont_engrave)='" & >> > Request.QueryString("find") & "')) OR (((Products.[pict >> > category])='" & Request.QueryString("find") & "')) OR >> > (((Products.product_code)='" & Request.QueryString("find") & >> > "')) OR (((Products.options) Like '*' & '" & >> > Request.QueryString("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.product_code, >> > Products.description, Products.price, >> > [images_add]+[product_code]+"".gif"" AS images, " & >> > Request.QueryString("[find]") & " AS byprodcat, >> > Products.options, Products.detailed_desc, Products.dont_engrave >> > FROM Products, Extras WHERE (((Products.price)<10) AND ((" & >> > Request.QueryString("[find]") & ")=""1"")) OR >> > (((Products.price)>10 And (Products.price)<20) AND ((" & >> > Request.QueryString("[find]") & ")=""2"")) OR >> > (((Products.price)>20 And (Products.price)<30) AND ((" & >> > Request.QueryString("[find]") & ")=""3"")) OR >> > (((Products.price)>30) AND ((" & Request.QueryString("[find]") & >> > ")=""4"")) OR (((Products.dont_engrave)=" & >> > Request.QueryString("[find]") & ")) OR (((Products.[pict >> > category])=" & Request.QueryString("[find]") & ")) OR >> > (((Products.product_code)=" & Request.QueryString("[find]") & >> > ")) OR (((Products.options) Like ""*"" & " & >> > Request.QueryString("[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******@hotmail.com> wrote in news:bp**********@hercules.btinternet.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.Querystring. Whyat is Request.Querystring?
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******@hotmail.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@localhost> wrote in message
news:ip********************************@4ax.com... On Sun, 23 Nov 2003 22:55:33 +0000 (UTC) in comp.databases.ms-access, "Peter" <pe******@hotmail.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.QueryString("find") & "' & '%')) ORDER BY
Products.price "
Peter
sql = "SELECT Products.[pict category], Products.product_code,
Products.description, Products.price, '" & Request.QueryString("find") & "'
AS byprodcat, Products.options, Products.detailed_desc,
Products.dont_engrave FROM Products WHERE (((Products.price)<10) AND (('"
& Request.QueryString("find") & "')='1')) OR (((Products.price)>10 And
(Products.price)<20) AND (('" & Request.QueryString("find") & "')='2')) OR
(((Products.price)>20 And (Products.price)<30) AND (('" &
Request.QueryString("find") & "')='3')) OR (((Products.price)>30) AND (('" &
Request.QueryString("find") & "')='4')) OR (((Products.dont_engrave)='" &
Request.QueryString("find") & "')) OR (((Products.[pict category])='" &
Request.QueryString("find") & "')) OR (((Products.product_code)='" &
Request.QueryString("find") & "')) OR (((Products.options) Like '%' & '" &
Request.QueryString("find") & "' & '%')) ORDER BY Products.price "
"Peter" <pe******@hotmail.com> wrote in message
news:bp**********@sparta.btinternet.com... Trevor
IT WORKED
Thank you very much to you Trevor and Bob for helping me out Thanks
Peter
"Trevor Best" <bouncer@localhost> wrote in message news:ip********************************@4ax.com... On Sun, 23 Nov 2003 22:55:33 +0000 (UTC) in comp.databases.ms-access, "Peter" <pe******@hotmail.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 =...
|
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...
|
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...
|
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...
|
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...
|
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?...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |