Wil — Fri, 12 Apr 2002 08:40:17 +0000

And I have no idea to be honest! I think it's just trying to retrieve the last inserted row (in a bad way, as there is a SQL command for this). I dunno.

Have you tried commenting out or deleting the line

$resultcg=$sthcg->fetchrow_hashref;

? As is, it seems redundant to me anyway.

Try that and see how you get on.

On a more general note; the level of programming is pretty poor and sketchy. What is the program? Maybe there are better alternatives around I can help you to look up.

Cheers

yabber — Thu, 11 Apr 2002 19:04:24 +0000

HI Wil,
Thanks for the answer, unfortunately I don't understand very much about perl at all
All I can figure out is that when a user logs in it removes the old cookie data from the DB and inserts new cookie data, it does seem to be doing that.
I have no idea what $resultcg is meant to return or how to find out
The script is so big that it's impossible to show it all here.
hmmmm what to do next ??

Mika

Wil — Thu, 11 Apr 2002 08:32:29 +0000

Ugh. You shouldn't call two database calls with the same session handle? That's really going to confuse things.

Anyway, the variable $resultcg - what _should_ it contain in your opinion? From what I can see you're only deleting and inserting things into your database - you're not _selecting_ anything - so how can a fetchrow_hashref contain anything if you're not selecting anything to fetch? That's basically a long winded version of your error message you're seeing.

So what is $resultcg meant to return?