Click here to Skip to main content
       

Visual Basic

 
AnswerRe: png lossless resize PinmemberRene Pilon4-Feb-13 6:54 
QuestionCustom Tab Control that I found on here PinmemberNSoft Studios3-Feb-13 13:10 
AnswerRe: Custom Tab Control that I found on here PinmvpDave Kreskowiak3-Feb-13 13:19 
GeneralRe: Custom Tab Control that I found on here PinmemberNSoft Studios3-Feb-13 13:44 
GeneralRe: Custom Tab Control that I found on here PinmvpRichard MacCutchan3-Feb-13 22:40 
QuestionRetrieving Custom Attributes PinmemberDisIsHoody1-Feb-13 21:34 
AnswerRe: Retrieving Custom Attributes PinmvpEddy Vluggen2-Feb-13 2:11 
QuestionSearch criteria - classic asp not working Pinmembermiss78631-Jan-13 4:01 
Dear all,
 
I am currently new into programming in classic asp and require little help in executing the following code:
 
<%
'collect the form input
searchInput = Request.QueryString("searchInput")
 
'check for a match
Set myRecordSet = Connect.Execute("SELECT * FROM dbo.tt WHERE cusip LIKE '%" & searchInput & "%' OR isin LIKE '%" & searchInput & "%'")
 

'display the results
if myRecordSet.EOF then
response.write("You searched for: " & searchInput & "
")
response.write("A match was not found.
Sorry try again.")
else
response.write("You searched for: " & searchInput & "
")
response.write("Records were found!
The matches are:
")
   do until myRecordSet.EOF
   response.write(myRecordSet("name") & "
")
   response.write(myRecordSet("cusip") & "
")
    response.write(myRecordSet("isin") & "
")
   myRecordSet.MoveNext
   loop
end if
%>
 
The search function does not perform accurately, as when I type in "123" in the search criteria, it display all the records, instead of specific records. It also display records, when I select submit button with blank search criteria.
 
Any help to overcome the following problem above. Thank you for your time and help.
AnswerRe: Search criteria - classic asp not working PinmvpEddy Vluggen31-Jan-13 10:18 
GeneralRe: Search criteria - classic asp not working Pinmembermiss7866-Feb-13 1:03 
GeneralRe: Search criteria - classic asp not working PinmvpEddy Vluggen6-Feb-13 7:11 
GeneralRe: Search criteria - classic asp not working Pinmembermiss7866-Feb-13 23:26 
GeneralRe: Search criteria - classic asp not working PinmvpEddy Vluggen7-Feb-13 8:13 
AnswerRe: Search criteria - classic asp not working PinmvpEddy Vluggen8-Feb-13 11:04 
QuestionWebBrowser Dock covers up statusstrip PinmemberNSoft Studios30-Jan-13 15:46 
AnswerRe: WebBrowser Dock covers up statusstrip PinmvpRichard MacCutchan30-Jan-13 22:13 
AnswerRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen30-Jan-13 22:36 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpDave Kreskowiak31-Jan-13 3:35 
SuggestionRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen31-Jan-13 3:38 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpDave Kreskowiak31-Jan-13 6:52 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen31-Jan-13 10:12 
GeneralRe: WebBrowser Dock covers up statusstrip PinmemberNSoft Studios3-Feb-13 12:58 
AnswerRe: WebBrowser Dock covers up statusstrip Pinmemberrohitvermasrt31-Jan-13 18:28 
QuestionQuery dataTable with .Compute Pinmembermebjen30-Jan-13 9:05 
AnswerRe: Query dataTable with .Compute PinmvpDave Kreskowiak30-Jan-13 10:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.140709.1 | Last Updated 10 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid