Richard S
Last Activity: May 14 '07, 06:38 PM
Joined: Apr 10 '07
Location:
-
no problem, thats why i posted... -
GOD I HATE IT WHEN THIS HAPPENDS :S
i post a message, and shortly after i find a solution :S
well il post it, might be usefull for others too!
is the code i use instead of:Code:searchparameter = searchterm.Replace(" ", "%' AND " + serialsearchin + " LIKE '%");
...Code:searchparameter = searchterm.Substring(searchterm.IndexOf(""), searchterm.LastIndexOf("Leave a comment:
-
Search for single, and multiple keywords (NO ACCESS PROBLEM!!)
CODE: ASP.NET with C#
DATABASE: ACCES
alright, im having a problem, probably a small thing, but i cant figure out, nor find it in any other post, or on the internet realy (probably cuz i wouldnt know what to search for), but heres the problem:
I am making a search function for my website, i want this to be possible:
- search for 1 keyword (the problem guy)
- search for multiple keywords
... -
altough it aint my thread, id like to thank you alot for this! helped me out alot! ty man...Leave a comment:
-
alright, srry for tripple post guys, but i figured it out, and i thought id let you guys know how...
this is the query i came up with:
the problem was that "SoftwareNa me =" should be "SoftwareNa me LIKE", LIKE helps you search for patterns :) so this fixed it!Code:"select * from serials where SoftwareName LIKE '%" + search + "%'"
thanks...Leave a comment:
-
ups, sorry i did something wrong!
i use this query now:
"select * from serials where SoftwareName = "%" + '" + box_searchfor.T ext + "' + "%";
witch gives me this error:
Newline in constant (this is selected when i double click the error: ";)Leave a comment:
-
"select * from serials where SoftwareName = " % " + '" + box_searchfor.T ext + "' + " % "";
that gives me the following error:
Operator '%' cannot be applied to operands of type 'string' and 'string'
on 2 locations:
"select * from serials where SoftwareName = "
and on:
"' + "
:(...Leave a comment:
-
AWESOME! thanks man :D really helped (and it worked :P)
but now i have the following thing, in my table i have a row with SoftwareName: Richard
now if i search for R, it finds nothing, and if i search for Richard, it does. how do i fix this?
i tried using this query:
"SELECT * FROM serials WHERE SoftwareName= '" + "*" + box_searchfor.T ext + "*" + "'"...Leave a comment:
-
ASP.NET problem
alright, first of all i love thise site, helped me out alot alreaddy, but now i have a problem witch i cant find a answer to after a LONG time of searching.
I am trying to make a small search, witch will search true my database table called "serials" in the colum "SoftwareNa me" for a match. but im having the biggest trouble in making it work. this is my code atm:
...Code:protected void btn_search_Click(object
No activity results to display
Leave a comment: