from a newbie.
Script language is ColdFusion on windows 2003
I have a dbase - MySQL 5 default table type where one table keeps
getting "locked" or perhaps unusable is a better term.
I can write to it but that is all.
Even using Query Browser I am not able to edit/or delete records. If I
drop the old table and create a new one all is well ( in Query Browser)
until I add or modify new records.
Here are the 2 queries I am using. Can any one see a cause in the
coding. I am not explicitly locking/unlocking - just a barebones write
to the BD.
Update existing record:
Update Equipinv.loaned Set loaned.returned = 'vartext1' where
((TrackNum = varInt1) and (loaned.returned = "0"))
Add new record
INSERT INTO EQUIPINV.loaned (loaned.trackNum, loaned.to,loaned.out,
loaned.due,loaned.student,loaned.returned)
VALUES (varInt2,'varText2', 'varText3', 'varText4',
varInt3,'varText5')
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
