coldfusion date insert problem(resolved)

how do i code some coldfusion insert data that can recieve date value:

eg:

<cfquery name="insdata" datasource="blabla">
insert into table1(name,dob)
values ('#form.namefield#','#form.dobfield#')
</cfquery>

this query give me error page....
so how do i code it? the right way?
please! please!:(

Code:

---



<cfquery name="insdata" datasource="blabla">
insert into table1(name,dob)
values ('#form.namefield#','#DateFormat(form.dobfield,"dd mm yyyy")#
')
</cfquery>

---

yes , no error page but the result is that when i call it back from database, the format is wrong..

eg: input in input box - 20 3 02 (dd m yy)

output using cfoutput - <cfoutput query="result">#date format(doe, "dd m yy")#</cfoutput> -----> resulted= 02 3 20 (yy m dd) :confused:

i don know what happend here....

ignore the 'date format' .....typing error..it should be ....dateformat(doe, "d m yy")

Solved?

nop...

OK, from what I understand, you're not getting it back in the proper format.

What format are you getting it as, and what format do you want?

i get yy mm dd format

i want ---> dd mm yy format.

even when i code the output this way....

<cfoutput query="viewdata">#dateformat(dob, "dd mm yy")#</cfoutput>

i still don get it right

thanks medhak!

i find another way around. i will only use character/string this time for the doe field. and create some javascript to validate date value.

:)
:D

Well... OK. :D