File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes ACCESS To MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ACCESS To MySQL" Watch "ACCESS To MySQL" New topic
Author

ACCESS To MySQL

Mathias Nilsson
Ranch Hand

Joined: Oct 13, 2003
Posts: 107
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


SCJP2 , MCP( 70-229 ) , Preparing For SCWDC
m hoque
Greenhorn

Joined: Oct 22, 2003
Posts: 3
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.
Mathias Nilsson
Ranch Hand

Joined: Oct 13, 2003
Posts: 107
Ok!

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

How do you do this in mySQL without having to do


// Mathias
[ November 10, 2003: Message edited by: Mathias Nilsson ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ACCESS To MySQL