Try using cf_sql_date I don't think date time is a valid option
A
Sent from my phone
--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAG1WijX%2BAcBb_W2myyrxLtVp17ftsG-XdgdwiFHGSmuyRpa52w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAFrbJ5UFai%3DxoeG6k%2BOrzdhukx-muLV8jHexW%2BcR%2BREVXjiA4Q%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/ab95fdbb-275d-435b-bcd5-d520ffd4bd3e%40googlegroups.com.
Hi Adam,Spot on, I just worked that out by looking at the CF11 docs (sorry Lucee docs you need examples!!!)...Also agree that it should have errored and not just assumed it was a string and escaped it and wrapped it in single quotes. I will raise a ticket.
--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAFwR%2BKdkp8Ytwb7RkidUzLJg59p07Lbz0htJ4bkU3qc_3UZSqA%40mail.gmail.com.
Ticket ref #215@Adam, you said "tickets" but I'm not sure what the other would be.
--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/a4343b84-9848-4dc4-80e3-24f6880abee8%40googlegroups.com.
If it assumed it was a string then surely escaping the single quotes would be correct?
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAG1WijUL5jHiqJPxpAzUCOyqD7Z2wz5bLUB_Pgcy6faqe43e5Q%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAGHrs%3D-8j9JfqJXhE8BNk2rLRx41b98P635cCz5sWJomtCL7Wg%40mail.gmail.com.
@Adam - No the escaping would be required for the data being passed to the SQL engine in the SQL statement, otherwise the SQL statement would not be valid. It doesn't matter if it is hard coded or passed in the variable, when passed to the SQL engine it would be passed as text either way. So if Lucee is assuming it is a string and adding the single quotes around it, then it must escape the single quotes inside it.
@Nando - I have raised the ticket and included an example query that will replicate the issue. I think my main issue was that it didn't error, despite the syntax being completely wrong. Like you say, using the correct syntax produces the correct result, but surely using the wrong syntax should produce an error!!!
--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAFwR%2BKcsXRk%2B%2Bc-ibdTrqHgU908KX%2BqacTRuNpRveJcLjqK48w%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAGHrs%3D-zCQYknwa60TY5yL0jw8ETiJ9yTqOvwEaFQh2pCaRhLg%40mail.gmail.com.