Solved

different query results depending on browser

Posted on 2009-04-06
6
186 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 500 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
Schedule a Tour of the ATEN booth at InfoComm 2017

Tour the ATEN booth to see the the Latest Addition to the Modular Matrix Switch Series, New 4K HDMI Over IP Extender and more! Enter ATEN's Ultimate Giveaway Sweepstakes for a chance to win one of several great prizes, including an ATEN US7220 2-Port Thunderbolt 2 Sharing Switch!

 

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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

705 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