Hi Ranchers! I want to switch from MS ACCESS 2000 to MySQL. I do not use embedded sql in java, only queries saved in access( some kind of stored procedures ). Many of my queries uses IIF() functions istead of CASE...WHEN. Since MySQL don't support stored procedures, yet, then what shall i do to make the queries work in MySQL. // MAthias
Hi sorry but as far as I know you don't have any other way then writing the queries in you application cause as you know mysql don't support stored procedure or views yet.
Joined: Oct 13, 2003
The how do you do a search in mySQL. Let's say a user can write in a name , from and to date and so on in a form and then click the search button. If the user dosn't write anything all records from the database will be retrived. If he writes a name the a like statement should be supplied. If doing this in a stroed procedure you write