From: Josh S. <jds...@un...> - 2002-08-19 11:17:50
|
Thanks for sending me this detail. I'm going to forward this to the mySiteMaker developer mailing list to see if the folks have any idea of what the problem is. Josh "Davis, Mike" wrote: > > Josh, > > The server is on an intranet behind a firewall and therefore can not be > reach. However, I will attempt to better describe the DB. > > Using Webmin (has a mySQL module) > I created a DB named : Cotraining > One Main Table named : cotrain > Table 'cotrain' consist of 11 fields - (Record_Number(int(5)-Primary Key- > auto increment), Date(varchar(10)), Employee(varchar(21)), > Manager(varchar(21)), Director(varchar(21)), Instructor(varchar(21)), > Vendor_Training(varchar(1)), Class Subject(varchar(25)), > Class_Time(char(2)), Hands_on(char(1)), Location(varchar(21)) > > I then used the url my site.../new_site.html using Cotraining & cotrain then > proceded to create pulldowns for the fields Manager(14 records), Director(3 > records), Vendor_Training (y/n (2records)), Class_Time(8 records), > Hands_on(y/n (2records)) > > After entering 17 records I realized that each record across on a search > displayed the correct data for each Employee however, if I clicked 'Edit' it > pulled up a different record (different Employee - (wrong Primary Key for > table cotrain)). The only way I get correct results is to sort the records > by Employee then 'Edit'- Primary Key is associated to the correct record. > Let me make it clear that no matter which column I sorted by other than > Employee I got a different but, incorrect primary key for the 'Edit' link. > All records maintained the correct data for each Employee it just seems > sorting by other than Employee result in an association of the wrong primary > key with "Edit" or "Delete" on the search results display screen. > > Also, note that I did not use the date varable because I did not like the > choice of formatting. My goal with this is to present a web base entry > solution and using the 'Excel' output to create presentable graphs & charts > from a Client PC. > > Josh I hope this painted a better picture and I appreciate your help. > Currently I am using Canned Queries which are working out OK... I think > maybe my REAL PROBLEM IS mySQL/PERL/NEWBIE :) > > THX FOR YOUR HELP > Mike > > -----Original Message----- > From: Josh Starmer [mailto:jds...@un...] > Sent: Sunday, August 18, 2002 9:50 AM > To: Davis, Mike > Subject: Re: mySiteMaker 3.6 > > I can't quite figure out what you are describing here. Could you give > me some more details and perhaps a URL to the mySite that you have > created so I can play with it and see for myself what it is doing? > > Josh > > "Davis, Mike" wrote: > > > > I was hoping you might have time to help a fledgling mySQL newbie. I use > > Webmin to create the intial DB (training), one table(train) with > > Record_number(auto-increment) as the key & 10 non-key fields - -- then I > > use mySiteMaker to create tables with pulldown menus to fill several of > the > > 10 non-key fields. When a search is performed it seems the DB is out of > > sync?? It seems to me the DB is sorting on the Key of the table > > associated with that column..???... If I sort based on the Employee field > ( > > not key of any table) -- this seems to sort right??? > > > > using mySiteMaker V 3.6 .... I would appreciate any sense you can make of > > this??? > > > > -Mike- |