mysql 5 vs. mysql 4: str_to_date

2006-04-21 Thread Vincente Aggrippino
The following query runs fine on my test server at home, running MySQL 5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it gets a syntax error. Can anyone help me figure out why? ... insert into product (name, url, cost, purchase_dt) values('Whatchamacallit',

Re: mysql 5 vs. mysql 4: str_to_date

2006-04-21 Thread Barry
Vincente Aggrippino wrote: The following query runs fine on my test server at home, running MySQL 5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it gets a syntax error. Can anyone help me figure out why? ... insert into product (name, url, cost, purchase_dt)

Re: mysql 5 vs. mysql 4: str_to_date

2006-04-21 Thread Dan Nelson
In the last episode (Apr 21), Vincente Aggrippino said: The following query runs fine on my test server at home, running MySQL 5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it gets a syntax error. Can anyone help me figure out why? ... insert into product (name, url,