Ask a Question related to Coldfusion Database Access, Design and Development.
-
dwf #1
Query to match date -- ODBD -- Access database
I am running CF5, and using ODBC to query an Access 2002 database. I think
these are the parts of my program that illustrate the problem:
<cfset RequestTime = createodbcdatetime(Now())>
dwf Guest
-
Query Access Via Date Ranges
Hey, crew... Just trying to figure out the best way to perform queries based on certain date ranges Example: Let's say I want to pull all... -
Question - query Access database
I removed the cfloop code and the query worked: <cfoutput query="statistics"> .. . . </cfoutput> instead of <cfoutput> <cfloop... -
Error Executing Access Database Query
The query works in 5, chokes in MX7 Error Message: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. ... -
Access Date Time Query
I am having some trouble with a query for Date Time in Access. I assume it is because the Access formatted date is Date/Time with stored data that... -
MS Access + date query
Hi I have got access table with two date/time field namely field1 and field2. I made one html form that inputs two dates (it's not mandatory... -
dwf #2 Re: Query to match date -- ODBC -- Access database
The SELECT should end with an "ORDER BY," rather than a "SORT BY," but that correction does not eliminate the error message regarding the date.
dwf Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
