>>>>> "Gary" == Gary Wong <gary.wong@stripped> writes:
Gary> Here's the relevant part of the MyODBC trace from the actual program
Gary> being run. It is attempting to update a record. Again, I didn't
Gary> create the actual query to pass to it. Thanks for all of your help...
Gary> Gary Wong
Gary> gary.wong@stripped
Hi!
>> | >mysql_real_query
>> | | enter: handle: 5d3e5c
>> | | query: Query = "UPDATE Specials SET AdType='ADVANTAGE ',ProductTextMain='Westpac Frozen 16 Oz. Cut Green Beans, Whole Kernel Corn, Green Peas, Chopped Broccol or Mixed Vegetables or 32 Oz. Crinkle or Steak Cut French Fries or Southern Style Hash Browns ',ProductTextSub='VOLUME+. Limit 2 FREE with Advantage Card and separate $20 purchase. ',ItemType1=339,ItemType2=27,ItemType3=39,Price='2 Free ',IMGPicture='104-1.gif ',Featured=1,StartDate=1999-10-04 00:00:00,EndDate=1999-10-14 00:00:00 WHERE (AdID=2704 AND AdType='ADVANTAGE' AND ProductTextMain='Westpac Frozen 16 Oz. Cut Green Beans, Whole Kernel Corn, Green Peas, Chopped Broccol or Mixed Vegetables or 32 Oz. Crinkle or Steak Cut French Fries or Southern Style Hash Browns' AND ProductTextSub='VOLUME+. Limit 2 FREE with Advantage Card and separate $20 purchase.' AND ItemType1=339 AND ItemType2=27 AND ItemType3=39 AND Price='2 Free' AND IMGPicture='104-1.gif' AND Featured=1 AND StartDate=1999-10-04 00:00:00 AND EndDate=1999-10-10 00:00:00 )"
The question is what happens before real_query?
Please mail directly to me everything between SQLPrepare and
mysql_real_query!
Regards,
Monty
