><cfquery name="charting" datasource="#dsn#">
>    SELECT *
>    FROM #tablename#
>    WHERE "#url.date#"
>    ORDER by date
>    LIMIT 31
>    </cfquery>

I don't use MySQL so maybe this is not the case, but don't you need to say something like: WHERE myDateColumn = #url.date#, rather than just WHERE #url.date# ?

Or does MySQL have some built-in thing where that's implied?

Just a thought.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to