Solved

different query results depending on browser

Posted on 2009-04-06
6
146 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
  • 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

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

Scale it in WD Gold

With up to ten times the workload capacity of desktop drives, WD Gold hard drives employ advanced technology to deliver among the best in reliability, capacity, power efficiency and performance.

Join & Write a Comment

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…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now