><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]
- Re: Help! - Dynamically Generate Forms from SQL DB - Bad... Claude Schneegans
- Re: Help! - Dynamically Generate Forms from SQL DB ... Claude Schneegans
- Re: Help! - Dynamically Generate Forms from SQL DB - Bad... Matt Robertson
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Matthew Walker
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Matthew Walker
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Micha Schopman
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Micha Schopman
- Small query question.. techmike
- Re: Small query question.. (Updated, SQL Syntax... Jason Lemahieu
- Re: Small query question.. (Updated, SQL Sy... techmike
- Re: Small query question.. (Updated, SQ... techmike
- Re: Small query question.. (Updated, SQ... Jochem van Dieten
- Re: Help! - Dynamically Generate Forms from SQL DB ... millerj
- Re: Help! - Dynamically Generate Forms from SQL DB ... Dan O'Keefe
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Micha Schopman