Sql returns rows but asp pg doesnt

csamuels · #1 (**permalink**) 05-24-06, 12:43

Code:

set conn = CreateObject("ADODB.Connection")
set sqlconn = CreateObject("ADODB.Connection")
set rs = CreateObject("ADODB.Recordset")

set conn = CreateObject("ADODB.Connection") 'prep connection'
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=" & sqlserver & ";UID=" & sqluser &_
             ";PWD=" & sqlpwd & ";DATABASE=" & sqldb

...

  query = "Select pluw, plua from agents where code = " & agentcode
  rs.open query, conn
  response.write query & "<BR>" 
  'response.write rs.fields("pluw") & " - " & rs.fields("plua") & "<BR>"
  if rs.eof then
    response.write "<font color=red><b>Agent Code not found</b></font><br><br>"

I'm connecting to SQL and running a query to return user initials for the specified code. Code is my primary key for the table. There are no other indexes or keys on the table.

The data I had in the table prior to creating the asp page is returned when entering its code. But if a new record is created, the asp page returns nothing and displays agent code not found. But i can copy the query generated by the asp page and have query analyzer return the record.

why cant I retrieve new records from sql using the asp page?

wayneph · #2 (**permalink**) 05-24-06, 14:33

1. Have you verified that the server/database parameters in your connection string are pointing to the same database you're pointing to with QA?
2. Have you cleared the Cache (Temporary Internet Files) in the browser to make sure you're not just seeing an old copy of the page?

csamuels · #3 (**permalink**) 05-24-06, 14:59

1. i can successfully query data that was in the table before the asp page was created.

2. i'll try then edit this post --> same result after clearing tmp inet cache

csamuels · #4 (**permalink**) 05-24-06, 15:05

**old data

**new data

**new data queried from sql

wayneph · #5 (**permalink**) 05-24-06, 15:16

Normally when I run into issues like this, I have my app pointing at a test database or something like that instead of production.

From the pieces you've shown us here, it looks like it should be working.

csamuels · #6 (**permalink**) 05-24-06, 16:04

right on the money. i was connecting to a test db instead of live.

Internet Services

Web Development

Digital Marketing

Consumer Tech