How do I get the "#" around dataes in an Insert into query?

[Ratbags21]

I am trying to use the "Insert Into" type "CFQUERY" and insert a date into a field.This date has been input by the user on a web form using the syntax "<input type="text" name="DateInTheatres"...>
The query is
<CFQuery datasource="blah">
Insert into Films(<other fields>,DateInTheatres)
values(<other fields>,#CreateODBCDate(Form.DateInTheatres)#)
</CFQuery>
The above code does not seem to work because the "#" are not automatically put to the left & right of the date so when the sql resolves you get 12/10/2009 (for example) no quotes, nothing.
How can I fix this?
many thanks
Paul

 

[r937]

###CreateODBCDate(Form.DateInTheatres)###


r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[cfSearching]

when the sql resolves you get 12/10/2009 (for example) no quotes, nothing

What do you mean does not work? There should not be any # signs in the output. CreateODBCDate() should produce a specially formatted date value that your database can understand. IIRC, it should looks something like this:

INSERT INTO Films( DateInTheatres )
VALUES( {d '2008-02-14'} )






----------------------------------

http://cfsearching.blogspot.com/