Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

different query results depending on browser

Posted on 2009-04-06
6
Medium Priority
?
194 Views
Last Modified: 2013-12-24
I have a query to bring back ALL records from a states table in a SQL 2008 db.
Using firefox the dynamically populated drop down shows every record.
Using IE... it skips one and so I can never have what's called "All States" which is the first row in the table.

Anyone else have this issue?
0
Comment
Question by:ecpeel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 16

Accepted Solution

by:
duncancumming earned 1500 total points
ID: 24081438
Could be a Javascript error?  Show us your code.
0
 

Author Comment

by:ecpeel
ID: 24081700
Query:
<cfquery name="getStates" datasource="#ds#">
SELECT dbo.states.stid, dbo.states.state_code, dbo.states.state_name
FROM dbo.states
ORDER BY 1
</cfquery>

<form  name="SearchGranteesForm"action="" method="post">
<table width="400" border="0">
  <tr>
    <td width="200">Grantee/Center name:</td>
    <td><input type="text"  width="200" value="" name="GranteeName" /></td>
  </tr>
  <tr>
    <td>Grant Number:</td>
    <td> <input type="text" width="200" value="" name="GrantNumber" /></td>
  </tr>
  <tr>
    <td>City:</td>
    <td><input type="text" width="200" value="" name="Center_City" /></td>
  </tr>
  <tr>
    <td>State: </td>
    <td><select name="Center_State" <cfoutput query="getStates"> <option value="#state_name#"> #state_name#</option></cfoutput></select></td>
  </tr>
  <tr>
    <td><input type="submit" name="btnSearch" value="Search"><input name="" type="submit" onClick="window.close()"  value="Clear"/></td>
    <td>&nbsp;</td>
  </tr>
</table>
</form> 

Open in new window

0
 

Author Comment

by:ecpeel
ID: 24082337
Here's what seemed to fix this:
I included a "reset" submit button and that did it. Without I believe the code was non-compliant HTML. Who knew IE would become so sensitive?
Thanks
0
Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

 

Author Closing Comment

by:ecpeel
ID: 31567223
I appreciate the effort as it lead me to reconsider important elements of HTML design.
0
 
LVL 16

Expert Comment

by:duncancumming
ID: 24084443
<tr>
    <td>State: </td>
    <td><select name="Center_State" <cfoutput query="getStates"> <option value="#state_name#"> #state_name#</option></cfoutput></select></td>
  </tr>
  <tr>
    <td><input type="submit" name="btnSearch" value="Search"><input name="" type="submit" onClick="window.close()"  value="Clear"/></td>
    <td> </td>
  </tr>


It may just be a cut-and-paste error, but your <select> tag hasn't got a closing >.  Should be
<select name="Center_State"> <cfoutput query="getStates">

Also I'm not sure if you can specify an empty name like this (why would you want to?)
name=""

And you're using XHTML style closing tags (the /> ), but that only works if your doctype is XHTML.  If it's HTML 4 those aren't valid.  But that shouldn't cause a problem for IE, it'll just render it in quirks mode.
0
 

Author Comment

by:ecpeel
ID: 24091579
@duncancumming:
I did catch that unclosed select tag after I posted. It didn't make the difference. I am using
"<html xmlns="http://www.w3.org/1999/xhtml">" but again it wasn't until I added a reset button that the query acknowledged the first row returned from the table.
Muchcho thanks.
I haven't attempted to duplicate the error by removing the reset button.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question