Neal Grosskopf Dot Com A NG Designs Site

Toolbar

  • Skip To
    • Menu
    • Content
  • Validate
    • HTML
    • CSS
    • WAI
  • Font Size
    • Small
    • Medium
    • Large
    • Extra Large
  • Account
    • Create Account
    • Login

Interact

Navigation

  • Home
  • Interact
    • Blog
    • Message Board
    • Open Links
    • Open Videos
    • Photo Gallery
    • Polls
    • Reviews
    • Geek Speak
  • Designs
    • View All Designs
    • Professional
    • Corporate
    • Templates
    • Personal
    • Club
    • NG Designs
    • Web Guides
  • Files
    • Artwork
    • Wallpapers
    • My File Downloads
  • Extras
    • Bookmarklets
    • The Magic 8-Ball
    • Monster.com RSS Feed Generator
Hey there, this site is pretty old now. I've decided to leave it up as I put a lot of work into it and would hate to see it disappear.

View Link Entry

  • Actions
    • New Open Link
    • View All
    • Search
    • Bookmarklet
    • Subscribe to RSS Feed
Web
( Add Link )
View External Link ADODB.Connection.Execute Vs ADODB.RecordSet.open
1/21/2009

ADODB.Connection.Execute Vs ADODB.RecordSet.open Something that's always confused me is the differences when opening recordsets with ASP. After doing some searching tonight I found this simple answer in this forum. Essentially when using Set rs = cn.Execute(sql) it opens a read only record set while when using rs.open(sql) it opens a recordset which could be read-only, write, etc. Supposedly the first version is more efficient if you're only reading through a table.

By: Neal Grosskopf

Tags: asp, programming ( Add Tag )


Replies:

  • Chris Retlich
    Chris Retlich
    #1

    Thu. January 22 2009, 11:01:33 PM

    And here I first thought your site was having some kind of database error when I saw the title to this link on the homepage. Also, various parts of your homepage, are inside scrollable boxes on IE8, especially the content in the right column.

  • Neal Grosskopf
    Neal Grosskopf
    #2

    Thu. January 22 2009, 6:27:34 PM

    Looks like IE8 can't follow it's own rules, especially when I already have the backwards compatible meta tag on my site i.e http-equiv="X-UA-Compatible" content="IE=7". The scrollbars appear because it must be choking on my overflow: auto; property which is what I use to give containers with floated children a height (so that adjacent elements clear it properly). Chris why are you using IE8 anyway?

  • Chris Retlich
    Chris Retlich
    #3

    Fri. January 23 2009, 9:37:17 AM

    I was running it since I was testing out the Windows 7 Beta under VirtualBox. Seems like a decent OS so far, then again, I've only used it for like 40 minutes.

  • Neal Grosskopf
    Neal Grosskopf
    #4

    Sat. January 24 2009, 7:04:20 PM

    I know I've read that they have different beta versions floating around. For example the Windows 7 beta might be one version of the beta while the official IE8 download is another. Either way, with the meta tag on my site, IE should render the site like it does in IE7.


Reply To This Post:
B U I Link Font Color Edit Preview ?
Characters: 0 Textbox Size: [+] [-]
   

Font Size:

  • A
  • A
  • A
  • A

Search:

What's Popular:

  • 8,435,871 Views
    How To Serve XHTML to Internet Explorer 6 And 7 as XML Using Content Negotiation
  • 282,870 Views
    Create a JQuery Content Slider Using Pure CSS
  • 252,412 Views
    CSS Browser Hacks For Firefox, Opera, Safari & Internet Explorer
  • 144,426 Views
    Converting A Site From Classic ASP To PHP: Some Things To Consider
 

Site Links

Site

  • About
  • Contact Me
  • Site Map
  • Site Search

Interact

  • Blog
  • Geek Speak
  • Message Board
  • Open Links
  • Open Videos
  • Photo Gallery
  • Polls
  • Reviews

Random Stuff

  • Hosting by Cloudways
  • © Copyright 2005 - 2025
  • Modified: Saturday, February 22, 2025
  • Load Time: 0 Seconds.
    Total Queries: 7

Site Coded And Designed By Neal Grosskopf Using No Crappy CMS Or Themes