[ciapug] weakly typed languages, etc.

[carl-olsen at mchsi.com]

I was talking about doing a query using PHP functions.  I don't know how MySQL handles quoted integers from the command line.  Some databases would give me an error if I put quotes around an integer, but PHP would take care of that for me by converting it to an integer.  I assume the behavior is intentional.

 -------------- Original message ----------------------
From: David Champion <dchampion at visionary.com>
> That's not being evaluated by PHP, it's being evaluated by MySQL. 
> Different issue.
> 
> If you go into MySQL and type the query with the quotes around the value 
> it will work just fine.
> 
> -dc
> 
> carl-olsen at mchsi.com wrote:
> > I've noticed a lot of books do a MySQL query like so "SELECT * FROM table 
> WHERE id = '1'".
> > 
> > If PHP did not convert that quoted number into an integer, it would throw an 
> error.
> > 
> > Most other databases would through an error if you put quotes around an 
> integer in the WHERE clause.
> > 
> > 
> >  -------------- Original message ----------------------
> > From: carl-olsen at mchsi.com
> >> concatenate "s" to the beginning of each string, then do the comparison, and 
> >> finally strip "s" from the beginning of each string.  Actually, adding any 
> >> "alpha" character to the string will prevent PHP from converting it to a 
> number.
> >> _______________________________________________
> >> ciapug mailing list
> >> ciapug at cialug.org
> >> http://cialug.org/mailman/listinfo/ciapug
> > 
> > 
> > _______________________________________________
> > ciapug mailing list
> > ciapug at cialug.org
> > http://cialug.org/mailman/listinfo/ciapug
> > 
> 
> 
> _______________________________________________
> ciapug mailing list
> ciapug at cialug.org
> http://cialug.org/mailman/listinfo/ciapug