Click here to Skip to main content
15,890,825 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Have annoying problem with formatting of hand-made tab control Pin
alexandis13-Feb-10 18:13
alexandis13-Feb-10 18:13 
GeneralRe: Have annoying problem with formatting of hand-made tab control Pin
Richard MacCutchan13-Feb-10 21:41
mveRichard MacCutchan13-Feb-10 21:41 
GeneralRe: Have annoying problem with formatting of hand-made tab control Pin
alexandis14-Feb-10 1:27
alexandis14-Feb-10 1:27 
QuestionCertain Flash banner development tips Pin
Honoy10-Feb-10 23:00
Honoy10-Feb-10 23:00 
QuestionNetwork Identification Card( NIC) restricted web-pages Pin
mir_ashraf_ali10-Feb-10 20:30
mir_ashraf_ali10-Feb-10 20:30 
Questionfiledownloadproblem(ASP) Pin
rajiv_kadam10-Feb-10 19:58
rajiv_kadam10-Feb-10 19:58 
AnswerRe: filedownloadproblem(ASP) Pin
T M Gray12-Feb-10 7:38
T M Gray12-Feb-10 7:38 
QuestionProblem accessing QueryString [modified] Pin
sduffield10-Feb-10 9:19
sduffield10-Feb-10 9:19 
Please help. Here is the record layout of my Access Database.

ID VENDNO VENDOR BEL COL HAR JEF MOR SUPNO SUPPLY

On my webpage I have an image of a five county area in Ohio with hotspots. (BEL, COL, HAR, JEF, MOR are those counties)When a visitor clicks on a county (the link looks like ?county=COL) then I want the code to show every vendor that does not have an "X" in the corresponding county. Here is the code I have so far:

<%
Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=ICDC_Brands"

Set recordSet=Server.CreateObject("ADODB.Recordset")
recordSet.Open "SELECT * FROM vendor", connectionToDatabase

if Request.QueryString("county") = "" then
Response.Write("")
elseif Request.QueryString("county") <> "" then
Do While NOT recordSet.EOF
I think this is problem line --> If recordSet("Request.QueryString") <> "X" Then
Response.Write(recordSet("VENDOR") & "<br>")
end if
recordSet.MoveNext
Loop
end if
connectionToDatabase.Close
Set connectionToDatabase=Nothing

%>
When I visit the page and click on a county, the web browser says:


ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/test/brands.asp, line 110

Any thoughts would be appreciated. Thank you
modified on Wednesday, February 10, 2010 3:47 PM

AnswerRe: Problem accessing QueryString Pin
thatraja10-Feb-10 18:41
professionalthatraja10-Feb-10 18:41 
GeneralRe: Problem accessing QueryString Pin
sduffield11-Feb-10 10:06
sduffield11-Feb-10 10:06 
AnswerRe: Problem accessing QueryString Pin
Nilesh Hapse10-Feb-10 20:06
Nilesh Hapse10-Feb-10 20:06 
AnswerRe: Problem accessing QueryString Pin
thatraja10-Feb-10 20:24
professionalthatraja10-Feb-10 20:24 
GeneralRe: Problem accessing QueryString Pin
Nilesh Hapse10-Feb-10 20:28
Nilesh Hapse10-Feb-10 20:28 
GeneralRe: Problem accessing QueryString [modified] Pin
thatraja10-Feb-10 23:04
professionalthatraja10-Feb-10 23:04 
GeneralRe: Problem accessing QueryString Pin
sduffield11-Feb-10 10:07
sduffield11-Feb-10 10:07 
QuestionPersonal website engine recommendation. Pin
Giorgi Dalakishvili10-Feb-10 7:34
mentorGiorgi Dalakishvili10-Feb-10 7:34 
QuestionLocations of aspnet files on Windows 7 Pin
Richard Jones10-Feb-10 6:23
Richard Jones10-Feb-10 6:23 
Questionput_innerText / CHTMLView::PutProperty Pin
GBrook10-Feb-10 5:51
GBrook10-Feb-10 5:51 
AnswerRe: put_innerText / CHTMLView::PutProperty Pin
GBrook11-Feb-10 4:53
GBrook11-Feb-10 4:53 
QuestionAccess Web application using IP from others system(In Office)... Pin
spalanivel9-Feb-10 2:28
spalanivel9-Feb-10 2:28 
QuestionEmbedding Flash Version 10 Pin
Paul McGann9-Feb-10 2:00
professionalPaul McGann9-Feb-10 2:00 
QuestionProblem after deployment. Pin
rksdev9-Feb-10 1:17
rksdev9-Feb-10 1:17 
Questionexporting to excel Pin
mabrahao8-Feb-10 8:34
mabrahao8-Feb-10 8:34 
AnswerRe: exporting to excel Pin
Gaurav Dudeja India8-Feb-10 20:15
Gaurav Dudeja India8-Feb-10 20:15 
GeneralRe: exporting to excel [modified] Pin
mabrahao9-Feb-10 1:18
mabrahao9-Feb-10 1:18 

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.