13 messages in com.mysql.lists.win32Re: Converting SQL from Access to MyS...
FromSent OnAttachments
Joelle Tegwen21 Oct 2005 10:11 
Leif Johnston21 Oct 2005 10:19 
Joelle Tegwen21 Oct 2005 10:37 
SGr...@unimin.com21 Oct 2005 10:41 
Daniel da Veiga21 Oct 2005 10:46 
SGr...@unimin.com21 Oct 2005 10:48 
Joelle Tegwen21 Oct 2005 10:58 
Joelle Tegwen21 Oct 2005 11:05 
SGr...@unimin.com21 Oct 2005 11:30 
Joelle Tegwen21 Oct 2005 12:33 
SGr...@unimin.com21 Oct 2005 12:55 
Joelle Tegwen21 Oct 2005 13:46 
jbon...@sola.com.au25 Oct 2005 15:44 
Subject:Re: Converting SQL from Access to MySQL 5.0 Using ASP interface
From:Joelle Tegwen (tegw@umn.edu)
Date:10/21/2005 10:37:45 AM
List:com.mysql.lists.win32

When the conversion goes live it will be on 2003. I'm just running it on my local host to get all the bugs worked out before I roll things out. Our test server is 2003 also.

I've got pretty clear instructions to get this site out of Access ASAP. Redesigning the architecture is only an option if it *won't work the way it does. We're planning some pretty major changes down the road but this is the way it is set up right now.

I am running this with transactions - at least I think I am. I was doing the transactions in ASP because access didn't have a mechanism and I rolled them over to MySQL, I think, but I don't know how to test if it works because I'm not sure how MySQL sends an error back to me to let me know there was an error (that doesn't stop the code).

Thanks Joelle

Leif Johnston wrote:

Where to begin. XP is not a server environment, so you should consider server 2000 or 2003.

Good db design does not agree with a record per field. Generally the form is a record with each field a part of the record allowing you to recover what was give to you. That will also agree better with the submission process 1 submission many fields in 1 record.

The many record process should require that you look at a transactional model or stored procedures for you control.

I strongly suggest that you step back and consider your design to correctly align the data to the database for the ultimate results you seek.