Member Avatar for showman13

Hi All,

Hopefully someone will have a quick answer for this question, because I'm in the middle of a time critical project and this is a stumbling block.

Here is what it is...

I have a temp_transaction table (mysql) that has various fields, one of which is a trans_date (datetime) field.

When I query the table, and assign the values to variables, the trans_date field displays just fine with the date and time.

But the next thing I want to do is to create a new record for a perm_transaction table.

When I create the insert statement using the variables that were assigned with the values from the query, and print out the insert statement, the values for the trans_date field are all zeros..

Any suggestions on why that might be, and how to correct it?

Thanks in advance.

I'm in a real time crunch here, so any help would be greatly appreciated.

Douglas

  • 1 Contributor
  • 1 Reply
  • 277 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by showman13
Member Avatar for showman13

OK... DUH!!!

That is what happens when you get in a hurry... you make stupid mistakes.

Sorry to have bothered you folks with this... I just made an error in my query.

thanks anyway.

douglas

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.