Incorrect Integer value

HI Ray

I've read through all the related articles for this error, but they're of no help.

I'm trying to delete an image, its thumbnail and database record, the delete button passes the url:

1-del-carousel-pic.php?tp_id=595

However, the attached page refuses to accept tp_id for some reason, and I get the error message

incorrect INTEGER value:

I've tried everything I can think of, but can't see what's wrong. When I run the query in the database, it returns the correct record.

Cheers

Chris

Line 14 you have:
$rsTopPics->bindParam("i", "".($rsTopPics->getColumnVal("tp_id")) ."", "-1"); //p1

You are trying to set a value in a recordset from the recordset itself. That doesn't make any sense, and it is probably the source of the error.

Thanks Ray - I must have rebuilt the recordset about 10 times!

Cheers

Chris

Hi Ray

I'm having the same issue on a different page (attached) but I can't see anything wrong!

The del-link.php returns 'incorrect integer value' so I click back - but the record has been deleted.

Cheers

Chris

Your trigger is set to always...

if ("" === "") {

I think you would want something like:

if (isset($_GET["$_GET['DistLinkID'])) {

or even:

if ($rsLink->getColumnVal("DistLinkID")) {

Hi Ray

Thanks - it was set for 'when page opens' in the behaviour.

I tried your suggestions and each time the redirect back to 1-links.php failed.

Cheers
Chris

I think I'll need screen sharing to debug this with you. I'm not sure where it is failing or what is going on without seeing it in context.

That would be great, thanks.

I'm in Spain at the moment, so early in our day (US time) would be better

Sorry, that should be early morning your time, which will be evening in Spain.

Thanks

Chris

I've reached out via skype... please reply there and we can coordinate a meeting.