List:MySQL ODBC« Previous MessageNext Message »
From:Michael Widenius Date:October 21 1999 12:52am
Subject:Re: Problem updating/inserting DATETIME data
View as plain text  
>>>>> "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
Thread
Problem updating/inserting DATETIME dataGary Wong20 Oct
  • Re: Problem updating/inserting DATETIME dataHendrik M.J. Arnoldus20 Oct
  • Re: Problem updating/inserting DATETIME dataGary Wong20 Oct
    • Re: Problem updating/inserting DATETIME dataMichael Widenius20 Oct
  • Problem updating/inserting DATETIME dataMichael Widenius20 Oct
  • Re: Problem updating/inserting DATETIME dataGary Wong21 Oct
    • Re: Problem updating/inserting DATETIME dataMichael Widenius21 Oct
  • Re: Problem updating/inserting DATETIME dataHendrik M.J. Arnoldus21 Oct
  • Re: Problem updating/inserting DATETIME dataGary Wong21 Oct
  • Re: Problem updating/inserting DATETIME dataGary Wong25 Oct
Re: Problem updating/inserting DATETIME dataMichael Widenius23 Oct