Ok, I just fuckin' give!

[BlackSnake]

I've been in this seat for nearly 12 hours and I still haven't solved this freakin problem.

Are there any jave gurus on board?

I got this freakin error: java.sql.SQLException: Invalid column index

The kicker is, there is no data. I wrote:

rs = stmt.executeQuery(strSQL);

if (rs != null)
{
rs.next();
intEmpl = rs.getInt(1);
strEmplName = rs.getString(2);
strEmplNet = rs.getString(3);
}

Why is the stupid thing reading inside the "if" statement? There is no data. The strSQL that is being executed bring back nothing. I made sure that it would bring back nothing and tested that it would not.

I'm going to a bar before going home. If anyone has an idea, I'll be back later. Thanks,

 

[Guest]

I've been in this seat for nearly 12 hours and I still haven't solved this freakin problem.

Are there any jave gurus on board?

I got this freakin error: java.sql.SQLException: Invalid column index

The kicker is, there is no data. I wrote:

rs = stmt.executeQuery(strSQL);

if (rs != null)
{
rs.next();
intEmpl = rs.getInt(1);
strEmplName = rs.getString(2);
strEmplNet = rs.getString(3);
}

Why is the stupid thing reading inside the "if" statement? There is no data. The strSQL that is being executed bring back nothing. I made sure that it would bring back nothing and tested that it would not.

I'm going to a bar before going home. If anyone has an idea, I'll be back later. Thanks,

heyas BS...
im not really good with java sql...so im not able to help all that much but check out this link... compare your program and see if you cant find the missing link.

dbforms

 

[Dar~]

what she said^^^

the only thing I can help with is es

 

[Liar]

Not a clue, bro. It looks to me like it should work. But I trust SQL servers as far as I can throw them.

 

[Quiet_Cool]

I've been in this seat for nearly 12 hours and I still haven't solved this freakin problem.

Are there any jave gurus on board?

I got this freakin error: java.sql.SQLException: Invalid column index

The kicker is, there is no data. I wrote:

rs = stmt.executeQuery(strSQL);

if (rs != null)
{
rs.next();
intEmpl = rs.getInt(1);
strEmplName = rs.getString(2);
strEmplNet = rs.getString(3);
}

Why is the stupid thing reading inside the "if" statement? There is no data. The strSQL that is being executed bring back nothing. I made sure that it would bring back nothing and tested that it would not.

I'm going to a bar before going home. If anyone has an idea, I'll be back later. Thanks,

Oh...

Now I see...

The answer is 4.



Q_C

 

[CrimsonMaiden]

No, the answer is 42. I thought everyone knew that.

(sorry for the hijack... back to your regularly scheduled thread)

 

[minsue]

Oh...

Now I see...

The answer is 4.



Q_C

. .

It's all greek to me, BS. Wanna flower?