Click here to Skip to main content
13,559,423 members

Visual Basic

 
AnswerRe: png lossless resize Pin
Rene Pilon4-Feb-13 6:54
memberRene Pilon4-Feb-13 6:54 
QuestionCustom Tab Control that I found on here Pin
NSoft Studios3-Feb-13 13:10
memberNSoft Studios3-Feb-13 13:10 
AnswerRe: Custom Tab Control that I found on here Pin
Dave Kreskowiak3-Feb-13 13:19
mvpDave Kreskowiak3-Feb-13 13:19 
GeneralRe: Custom Tab Control that I found on here Pin
NSoft Studios3-Feb-13 13:44
memberNSoft Studios3-Feb-13 13:44 
GeneralRe: Custom Tab Control that I found on here Pin
Richard MacCutchan3-Feb-13 22:40
mvpRichard MacCutchan3-Feb-13 22:40 
QuestionRetrieving Custom Attributes Pin
DisIsHoody1-Feb-13 21:34
memberDisIsHoody1-Feb-13 21:34 
AnswerRe: Retrieving Custom Attributes Pin
Eddy Vluggen2-Feb-13 2:11
mvpEddy Vluggen2-Feb-13 2:11 
QuestionSearch criteria - classic asp not working Pin
miss78631-Jan-13 4:01
membermiss78631-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 & "<br>")
response.write("A match was not found.<br>Sorry try again.")
else
response.write("You searched for: " & searchInput & "<br>")
response.write("Records were found!<br>The matches are:<br>")
   do until myRecordSet.EOF
   response.write(myRecordSet("name") & "<br>")
   response.write(myRecordSet("cusip") & "<br>")
    response.write(myRecordSet("isin") & "<br>")
   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 Pin
Eddy Vluggen31-Jan-13 10:18
mvpEddy Vluggen31-Jan-13 10:18 
GeneralRe: Search criteria - classic asp not working Pin
miss7866-Feb-13 1:03
membermiss7866-Feb-13 1:03 
GeneralRe: Search criteria - classic asp not working Pin
Eddy Vluggen6-Feb-13 7:11
mvpEddy Vluggen6-Feb-13 7:11 
GeneralRe: Search criteria - classic asp not working Pin
miss7866-Feb-13 23:26
membermiss7866-Feb-13 23:26 
GeneralRe: Search criteria - classic asp not working Pin
Eddy Vluggen7-Feb-13 8:13
mvpEddy Vluggen7-Feb-13 8:13 
AnswerRe: Search criteria - classic asp not working Pin
Eddy Vluggen8-Feb-13 11:04
mvpEddy Vluggen8-Feb-13 11:04 
QuestionWebBrowser Dock covers up statusstrip Pin
NSoft Studios30-Jan-13 15:46
memberNSoft Studios30-Jan-13 15:46 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
Richard MacCutchan30-Jan-13 22:13
mvpRichard MacCutchan30-Jan-13 22:13 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen30-Jan-13 22:36
mvpEddy Vluggen30-Jan-13 22:36 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Dave Kreskowiak31-Jan-13 3:35
mvpDave Kreskowiak31-Jan-13 3:35 
SuggestionRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen31-Jan-13 3:38
mvpEddy Vluggen31-Jan-13 3:38 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Dave Kreskowiak31-Jan-13 6:52
mvpDave Kreskowiak31-Jan-13 6:52 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen31-Jan-13 10:12
mvpEddy Vluggen31-Jan-13 10:12 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
NSoft Studios3-Feb-13 12:58
memberNSoft Studios3-Feb-13 12:58 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
rohitvermasrt31-Jan-13 18:28
memberrohitvermasrt31-Jan-13 18:28 
QuestionQuery dataTable with .Compute Pin
mebjen30-Jan-13 9:05
membermebjen30-Jan-13 9:05 
AnswerRe: Query dataTable with .Compute Pin
Dave Kreskowiak30-Jan-13 10:20
mvpDave Kreskowiak30-Jan-13 10:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web02-2016 | 2.8.180515.1 | Last Updated 27 May 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid