Type mismatch ?

Anon

Hello!

On the line $nummer = '$id' I got type error/type missmatch (my translation to English from swedish) ;-(

Thanks in advance.

Klas

if($radera)
{
?>
<form action="" method="POST">
<br>
ID:
<input name="nummer" size="5"><br>
<input type="submit" name="radera2" value="Press here!">
</form>
<?php } ?>

<?php
if($radera2)
{
echo "$nummer";

$connect = odbc_connect("skivor", "Orvar", "hejsan44") or die("No DNS

$query = "delete from discografi where $nummer = '$id'";

$result = odbc_do($connect, $query) or die("Could not connect");

odbc_close($connect);

}
?>

Anon

I'm guessing that the problem is with the '' in the line

$query = "delete from discografi where $nummer = '$id'";

... and when $nummer refers to a numeric field the database is going "But that's a string value! Yuck!".

If $nummer always refers to numeric fields, then the line should probably be

$query = "delete from discografi where $nummer = $id";

But if it could be numeric or string, then some way of checking would be needed.

Let us know if dropping the '' helps.

Anon

Hello ;-)

($nummer is always refering to numeric field)

When I tried that(dropping the '') I got another error instead.

I translate it to English(28 was the id number I tried to delete)
:

"Warning: SQL error: [Microsoft][Driver for ODBC Microsoft Access] Syntaxerror (operator missing) in the query '28 ='., SQL state 37000 in SQLExecDirect in ...

I would be really happy for more help. ;-)

Klas

(In Swedish for anyone who want's a language lession ;-)
Warning: SQL error: [Microsoft][Drivrutin för ODBC Microsoft Access] Syntaxfel (operator saknas) i frågeuttrycket '28 ='., SQL state 37000 in SQLExecDirect in

Anon

Um, I think I see what's going on. The name of the field is id, and the value you're wanting to delete is 28, yes? You're wanting to delete the record in the discography with an id of 28?

I think your field and value are mixed up; try:

delete from discografi where id=$nummer

Anon

Maybe there is some way to change the string
$nummer to an int?

Klas

Anon

delete from discografi where id=$nummer did it!!!

Thanks really, I have been on this one for hours.

Klas

Anon

No need for that now, problem solved. ;-)

Thanks Grumbler.

Klas