Click here to Skip to main content
13,794,059 members

Visual Basic

 
AnswerRe: png lossless resize Pin
237414-Feb-13 7:54
member237414-Feb-13 7:54 
QuestionCustom Tab Control that I found on here Pin
NSoft Studios3-Feb-13 14:10
memberNSoft Studios3-Feb-13 14:10 
AnswerRe: Custom Tab Control that I found on here Pin
Dave Kreskowiak3-Feb-13 14:19
mvpDave Kreskowiak3-Feb-13 14:19 
GeneralRe: Custom Tab Control that I found on here Pin
NSoft Studios3-Feb-13 14:44
memberNSoft Studios3-Feb-13 14:44 
GeneralRe: Custom Tab Control that I found on here Pin
Richard MacCutchan3-Feb-13 23:40
protectorRichard MacCutchan3-Feb-13 23:40 
QuestionRetrieving Custom Attributes Pin
Dominick Marciano1-Feb-13 22:34
professionalDominick Marciano1-Feb-13 22:34 
AnswerRe: Retrieving Custom Attributes Pin
Eddy Vluggen2-Feb-13 3:11
professionalEddy Vluggen2-Feb-13 3:11 
QuestionSearch criteria - classic asp not working Pin
miss78631-Jan-13 5:01
membermiss78631-Jan-13 5: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 11:18
professionalEddy Vluggen31-Jan-13 11:18 
GeneralRe: Search criteria - classic asp not working Pin
miss7866-Feb-13 2:03
membermiss7866-Feb-13 2:03 
GeneralRe: Search criteria - classic asp not working Pin
Eddy Vluggen6-Feb-13 8:11
professionalEddy Vluggen6-Feb-13 8:11 
GeneralRe: Search criteria - classic asp not working Pin
miss7867-Feb-13 0:26
membermiss7867-Feb-13 0:26 
GeneralRe: Search criteria - classic asp not working Pin
Eddy Vluggen7-Feb-13 9:13
professionalEddy Vluggen7-Feb-13 9:13 
AnswerRe: Search criteria - classic asp not working Pin
Eddy Vluggen8-Feb-13 12:04
professionalEddy Vluggen8-Feb-13 12:04 
QuestionWebBrowser Dock covers up statusstrip Pin
NSoft Studios30-Jan-13 16:46
memberNSoft Studios30-Jan-13 16:46 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
Richard MacCutchan30-Jan-13 23:13
protectorRichard MacCutchan30-Jan-13 23:13 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen30-Jan-13 23:36
professionalEddy Vluggen30-Jan-13 23:36 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Dave Kreskowiak31-Jan-13 4:35
mvpDave Kreskowiak31-Jan-13 4:35 
SuggestionRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen31-Jan-13 4:38
professionalEddy Vluggen31-Jan-13 4:38 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Dave Kreskowiak31-Jan-13 7:52
mvpDave Kreskowiak31-Jan-13 7:52 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen31-Jan-13 11:12
professionalEddy Vluggen31-Jan-13 11:12 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
NSoft Studios3-Feb-13 13:58
memberNSoft Studios3-Feb-13 13:58 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
rohitvermasrt31-Jan-13 19:28
memberrohitvermasrt31-Jan-13 19:28 
QuestionQuery dataTable with .Compute Pin
mebjen30-Jan-13 10:05
membermebjen30-Jan-13 10:05 
AnswerRe: Query dataTable with .Compute Pin
Dave Kreskowiak30-Jan-13 11:20
mvpDave Kreskowiak30-Jan-13 11: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 | Cookies | Terms of Service
Web06 | 2.8.181207.3 | Last Updated 10 Dec 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid