Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an entry, I try an insert:
INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES
(209689,'2005-06-26',1)
The execute function indicated success.
But then (sometimes) it tells me I have a duplicate entry:
DBD::mysql::st execute failed: Duplicate entry '209689-2005-06-26' for key 1
at ./crawl-hot-jobs.pl line 675.
How could this be?
Now here is another example where I detect a duplicate and delete the
statement before trying to insert:
DELETE jobtitlecount WHERE dtSnapShot ='2005-06-26' AND fkJobPosting =
211151
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE dtSnapShot ='2005-06-26' AND fkJobPosting =
211151' at li at ./crawl-hot-jobs.pl line 686.
I don't see any syntax error in that DELETE statement: do you?
The primary key consists of two fields: fkJobPosting (integer) and
dtSnapshot (date).
Now if my SQL had a syntax error, would it not give me an error every time?
So why do I get syntax error?
I don't get a syntax error every time. These errors are very eratic and I
cannot discern what is different when these errors occur.
Thanks,
Siegfried
---
683 insert failed: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot,
cJobTitle) VALUES (209689,'2005-06-26',1) /try delete: 'DELETE jobtitlecount
WHERE dtSnapShot ='2005-06-26' AND fkJobPosting = 209689'
select='SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26''Duplicate entry '209689-2005-06-26' for key 1
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE dtSnapShot ='2005-06-26' AND fkJobPosting =
209689' at li at ./crawl-hot-jobs.pl line 686.
Use of uninitialized value in concatenation (.) or string at
./crawl-hot-jobs.pl line 707.
707 $nDBVersion[0] = 1 version=1 nDBVersion=() fkJobId = 209689 No need to
update database,it is more recent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]