---
title: "Ogiltig markörstatus"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/67043-ogiltig-markörstatus"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "AG"
published: "2003-02-03T14:08:40.000Z"
updated: "2003-02-03T14:36:57.000Z"
replies: 3
views: 595
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/67043-ogiltig-markörstatus"
---

# Ogiltig markörstatus

## #1 — AG, 2003-02-03T14:08Z

Vad beror ett sådant felmeddelande på?
Bifigar sqlsatsen.

```
String sql = "SELECT * FROM [URLS] WHERE [IdUser] = " + Integer.parseInt(this.User) + "";
```

Andreas

Permalänk: https://www.webforum.nu/p/67043

## #2 — SPiN, 2003-02-03T14:16Z

Det har inte att göra med pekaren mot tabellrad i Java-delen, då? Du kanske har missat att flytta pekaren till en rad, eller har flyttat den till en ogiltig.

```
ResultSet resultSet = stmt.executeQuery( "SELECT * FROM [blah]" );
resultSet.absolute( 3 ); // Flyttar pekaren till rad tre i returnerad tabell
resultSet.next(); // Flyttar till nästa rad
```

Permalänk: https://www.webforum.nu/p/936981

## #3 — AG, 2003-02-03T14:21Z

Kanske detta

```
public String doQuery() throws ClassNotFoundException, SQLException {
// Class.forName(dbDriver);
Class.forName(dbDriver);
dbCon = DriverManager.getConnection(dbURL,"","");
Statement s = dbCon.createStatement();
int val = Integer.parseInt(this.User);
String sql = "SELECT * FROM [URLS] WHERE [IdUser] = " + val +""; 

//System.out.println("sql : "+sql);
ResultSet rs = s.executeQuery(sql);
String rt = "";

try{
int priority = rs.getInt(4);  
int email = rs.getInt(5);
int icq = rs.getInt(6);
int sms = rs.getInt(7);
while (rs.next()) {
String urlresponse;
urlresponse = "<font color=red>not responding</font>";
if (priority == 0) { 
	urlresponse = "<font color=green>responding</font>"; 
}

String emailchecked;
emailchecked = "no";
if (email != 0) { 
	emailchecked = "yes"; 
}

String smschecked;
smschecked = "no";
if (sms != 0) { 
	smschecked = "yes"; 
}

String icqchecked;
icqchecked = "no";
if (icq != 0) { 
	icqchecked = "yes"; 
}
rt = rt + "<tr> <td>" + rs.getString("url") + "</td>";
rt = rt + "<td>" + emailchecked + "</td>";
rt = rt + "<td>" + icqchecked + "</td>";
rt = rt + "<td>" + smschecked + "</td>";
rt = rt + "<td>" + urlresponse + "</td></tr>";
}
}
```

Det är den koden som berörs, testade skriva ut sqlsatsen och den verkade stämma.

Andreas

Permalänk: https://www.webforum.nu/p/936985

## #4 — AG, 2003-02-03T14:36Z

Återgärdat. felet låg i hanteringen av resultset.

Andreas

Permalänk: https://www.webforum.nu/p/936992

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/67043-ogiltig-markörstatus