odd recordset error - ASP / Active Server Pages

sweep2005

Hi,

Can anyone help, I have developed a website using ASP for a client and
have deployed it on their server. While the code works fine on our test
server an odd error occurs on theirs, the recordsets become read once,
basically once I have output to screen or used in an IF statement the
recordsets data is no longer available to use again. eg:

1st time used on page:
<% = rs("name") %> ' This works fine

2nd time used on page:
<% = rs("name") %> ' This does nothing, the recordset is effectivly
empty.

BTW. Both me and my client are running windows server 2003.

Any help would be much appreciated.

thanks

Chris

--
sweep2005
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1070768.html

Jul 22 '05 #1

Subscribe Post Reply

1049

Mark Schupp

See if this helps.
http://www.aspfaq.com/show.asp?id=2188

If it doesn't then post your code.
--
--Mark Schupp
"sweep2005" <sw**************@mail.webservertalk.com> wrote in message
news:sw**************@mail.webservertalk.com...

Hi,

Can anyone help, I have developed a website using ASP for a client and
have deployed it on their server. While the code works fine on our test
server an odd error occurs on theirs, the recordsets become read once,
basically once I have output to screen or used in an IF statement the
recordsets data is no longer available to use again. eg:

1st time used on page:
<% = rs("name") %> ' This works fine

2nd time used on page:
<% = rs("name") %> ' This does nothing, the recordset is effectivly
empty.

BTW. Both me and my client are running windows server 2003.

Any help would be much appreciated.

thanks

Chris

--
sweep2005
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1070768.html

Jul 22 '05 #2

sweep2005

Cheers will give this a go.

thanks

--
sweep2005
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1070768.html

Jul 22 '05 #3

Similar topics

Use a recordset inside a Function?

by: David Berry | last post by:

I'm trying to use a recordset inside of a function but I'm getting an "object required 'adoRS" error. At the top of the page I create my recordset, ex: dim strConnection, adoCN, adoRS, strSQL...

ASP / Active Server Pages

Recordset Errors / Friendly Message needed

by: dmiller23462 | last post by:

My brain is nuked....Can anybody tell me right off the bat what is wrong with this code? Along with any glaring errors, please let me know the syntax to display a message (Response.Write would be...

ASP / Active Server Pages

Please help - trying to return XML from a recordset

by: Alan Silver | last post by:

Hello, I have an ASP that takes a connection string and SQL statement in the querystring and is supposed to return the XML representation of the recordset to the Response stream (don't worry,...

ASP / Active Server Pages

ADODB.Recordset - referring to a field

by: Simone | last post by:

Hello I hope you guys can help me. I am very new to ADO... I am creating a ADODB connection in a module and trying to access it from a command button in a form. Function fxEIDAssgn(plngEID As...

Microsoft Access / VBA

Calling a recordset from a function.

by: Gerry Abbott | last post by:

Hi all. I wish to call a recordset from a function. Ive tried the following approach, -------------------------------------------------------- Function PassRS() As Recordset Dim db As...

Microsoft Access / VBA

Set Form Recordset as ADO Recordset

by: ano1optimist | last post by:

I have a form with a search button. I'm using command parameters to pass search criteria to a stored procedure. Here is my code: Stored procedure: CREATE PROCEDURE . @strCriteria varchar(200)...

Microsoft Access / VBA

Error trapping ignored on second pass (DAO recordset duplicates error 3022)

by: Nathan Bloomfield | last post by:

Hi there, I am having difficulty with a piece of code which would work wonders for my application if only the error trapping worked properly. Basically, it works as follows: - adds records...

Microsoft Access / VBA

DAO.recordset

by: marmottedodue | last post by:

Hello, I'm trying to debug an access project in which two kind of recordset are used: ADODB.recordset and DAO.recordset. I'm trying to set the whole project on DAO.recordset, but the following...

Microsoft Access / VBA

RecordSet update insert error & sql insert syntax error

by: technocraze | last post by:

Hi guys, I have encountered this error when updating the values to the MS Acess table. Error : Update on linked table failed. ODBC sql server error Timeout expired. MS Acess is my front end and...

Microsoft Access / VBA

ASP vbscript recordset paging headache

by: wallconor | last post by:

Hi, I am having a problem using Dreamweaver CS3 standard recordset paging behavior. It doesn’t seem to work when I pass parameter values from a FORM on my search page, to the recordset on my...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice