Click here to Skip to main content
13,597,455 members

Visual Basic

 
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 
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 
miss786 wrote:
I am not sure what you mean by "Can you verify that the dataset is empty, "before" you execute the query"?

The result of the query is loaded into a dataset; that's an object that gets created somewhere, and it might already contain data - since the query looks correct, I'm wondering where these other records came from, and it might be that they were there before the query executed.

I doubt that this is the problem, as the object "should" be replaced with a new one on the line where the query executes;
Set myRecordSet = ...


miss786 wrote:
This query would always give the output of records a1 and b1 but how can i build a search criteria for the client side, if the user enters "us" in the search criteria, it would show record "e1" or the id the user enters "00", it would show an error saying to "try again, no record found", or if the user searches "3" in the criteria, it would show records "a1, b1 and c1" and so on.

We verified the query yesterday, and it is correct. The ASP-code looks correct too, meaning that it places the user-input in the right spot.

The code below should print the query that's being built in the output-window of the VS-IDE. You might want to check whether the generated query looks as expected (I see no reason why not) and whether it runs when you execute it directly on the server.
'check for a match
Dim myQuery As String = "SELECT * FROM dbo.tt WHERE cusip LIKE '%" & searchInput & "%' OR isin LIKE '%" & searchInput & "%'"
Debug.Print(myQuery)
Set myRecordSet = Connect.Execute(myQuery)

If all else fails, I'll debug it in the weekend. Already got the query and the relevant piece of ASP, so I could try and build it.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

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 
GeneralRe: Query dataTable with .Compute Pin
mebjen30-Jan-13 10:45
membermebjen30-Jan-13 10:45 
GeneralRe: Query dataTable with .Compute Pin
Dave Kreskowiak30-Jan-13 14:28
mvpDave Kreskowiak30-Jan-13 14:28 
QuestionWindows admin mode mistries Pin
solankinkdpr30-Jan-13 1:11
membersolankinkdpr30-Jan-13 1:11 
AnswerRe: Windows admin mode mistries Pin
Eddy Vluggen30-Jan-13 7:51
mvpEddy Vluggen30-Jan-13 7:51 
GeneralRe: Windows admin mode mistries Pin
solankinkdpr30-Jan-13 19:07
membersolankinkdpr30-Jan-13 19:07 

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
Web04 | 2.8.180621.3 | Last Updated 24 Jun 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid