Re: Trap mySQL error code vs test query ?

[Arthur Chan]

Yes, I am heading down that path. User enter parameters in JAVA, then execute multiple SQL queries in PHP, the 1st of which is to check for dup (its a foreign key constraint). If no dups, then insert.

Incidentally, I find coding in Android a bit easier because of the char-encoding problems I had earlier and I am still having some trouble when I try to insert INT or FLOAT (I type cast the uploaded params in PHP)...

Thanks for the feedback :)