0

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
2
Views
6 Years
Discussion Span
Last Post by showman13
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.