•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 425,917 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,711 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser: Programming Forums
Views: 6944 | Replies: 16
 |
| |
•
•
Join Date: Jul 2005
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I would like to create a page which will pull news items according to today's date. What I have is a database which users input thier news information. But now I need to have the information output to a page which will change daily according to the current date. The BeginDate fields and EndDate fields are in date format in my database. Here's what I have to work with...
<!---Retrieve news from database--->
<cfquery name="NewsQuery" datasource="News">
SELECT *
FROM News
WHERE BeginDate <= '#Dateformat(Now(), "mm/dd/yyyy")#'
AND EndDate >= '#Dateformat(Now(), "mm/dd/yyyy")#'
</cfquery>
<!---Output news to page--->
<cfoutput query="NewsQuery">
<p>
#NewsTitle#
#NewsDesc#
#NewsDate#
</p>
</cfoutput>
Anything specific you can provide me with is greatly appreciated. Please provide me some code... I've been working on trying to get this to work for weeks!
Thanks for your help!!! :eek: :mrgreen:
<!---Retrieve news from database--->
<cfquery name="NewsQuery" datasource="News">
SELECT *
FROM News
WHERE BeginDate <= '#Dateformat(Now(), "mm/dd/yyyy")#'
AND EndDate >= '#Dateformat(Now(), "mm/dd/yyyy")#'
</cfquery>
<!---Output news to page--->
<cfoutput query="NewsQuery">
<p>
#NewsTitle#
#NewsDesc#
#NewsDate#
</p>
</cfoutput>
Anything specific you can provide me with is greatly appreciated. Please provide me some code... I've been working on trying to get this to work for weeks!
Thanks for your help!!! :eek: :mrgreen:
•
•
Join Date: Jul 2005
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
By the way I'm using an Access database
•
•
Join Date: Jun 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 1
Newbie Poster
What is your issue specifically? What error do you get or not get?
One issue could be access way of formatting the Date:
Try Removing the mm/dd/yy mask
One issue could be access way of formatting the Date:
Try Removing the mm/dd/yy mask
•
•
Join Date: Jul 2005
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thank you for your reply!
Well with the code I recieve the following message:
==============================================================
Error Occurred While Processing Request
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Table 'News' is exclusively locked by user 'Admin' on machine 'MY_PC'.
The Error Occurred in C:\CFusionMX\wwwroot\News\test.cfm: line 20
18 : </head>
19 :
20 : <body>
21 : <cfoutput query="NewsQuery">
22 : <p>
--------------------------------------------------------------------------------
SQL SELECT * FROM News WHERE StartDate <= '07/27/2005' AND StopDate >= '07/27/2005'
DATASOURCE News
VENDORERRORCODE -1302
SQLSTATE HY000
Please Try The Following:
Check the CFML Reference Manual to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322)
Remote Address 127.0.0.1
Referer
Date/Time 27-Jul-05 08:49 AM
Stack Trace (click to expand)
at cftest2ecfm599768075.runPage(C:\CFusionMX\wwwroot\News\test.cfm:20) at cftest2ecfm599768075.runPage(C:\CFusionMX\wwwroot\News\test.cfm:20)
java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Table 'News' is exclusively locked by user 'Admin' on machine 'MY_PC'.
at com.merant.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
at com.merant.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeBody(Unknown Source)
at com.merant.sequelink.ssp.Chain.decode(Unknown Source)
at com.merant.sequelink.ssp.Chain.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.CreatedStmtCtxt.getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._execDirect(Unknown Source)
at com.merant.sequelink.ctxt.stmt.CreatedStmtCtxt.execDirect(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkStatement._execute(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkStatement.execute(Unknown Source)
at jrun.sql.JRunStatement.execute(JRunStatement.java:304)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at cftest2ecfm599768075.runPage(C:\CFusionMX\wwwroot\News\test.cfm:20)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
=============================================================
I removed the mask. I still get the error. If I remove the WHERE statement then it works. Pulling all the information from the database. All I want is for the query to look at my news database go to the BeginDate and EndDate fields and determine if it is within the time range for the time which it is to be presented. I want it to check and say today is 7/27/2005, is there any news item which needs to be presented today? I hope that helps. If it's not clear please let me know. I really appreciate your help! You dont know how frustrated I am with this.
Well with the code I recieve the following message:
==============================================================
Error Occurred While Processing Request
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Table 'News' is exclusively locked by user 'Admin' on machine 'MY_PC'.
The Error Occurred in C:\CFusionMX\wwwroot\News\test.cfm: line 20
18 : </head>
19 :
20 : <body>
21 : <cfoutput query="NewsQuery">
22 : <p>
--------------------------------------------------------------------------------
SQL SELECT * FROM News WHERE StartDate <= '07/27/2005' AND StopDate >= '07/27/2005'
DATASOURCE News
VENDORERRORCODE -1302
SQLSTATE HY000
Please Try The Following:
Check the CFML Reference Manual to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322)
Remote Address 127.0.0.1
Referer
Date/Time 27-Jul-05 08:49 AM
Stack Trace (click to expand)
at cftest2ecfm599768075.runPage(C:\CFusionMX\wwwroot\News\test.cfm:20) at cftest2ecfm599768075.runPage(C:\CFusionMX\wwwroot\News\test.cfm:20)
java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Table 'News' is exclusively locked by user 'Admin' on machine 'MY_PC'.
at com.merant.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
at com.merant.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeBody(Unknown Source)
at com.merant.sequelink.ssp.Chain.decode(Unknown Source)
at com.merant.sequelink.ssp.Chain.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.CreatedStmtCtxt.getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._execDirect(Unknown Source)
at com.merant.sequelink.ctxt.stmt.CreatedStmtCtxt.execDirect(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkStatement._execute(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkStatement.execute(Unknown Source)
at jrun.sql.JRunStatement.execute(JRunStatement.java:304)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at cftest2ecfm599768075.runPage(C:\CFusionMX\wwwroot\News\test.cfm:20)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
=============================================================
I removed the mask. I still get the error. If I remove the WHERE statement then it works. Pulling all the information from the database. All I want is for the query to look at my news database go to the BeginDate and EndDate fields and determine if it is within the time range for the time which it is to be presented. I want it to check and say today is 7/27/2005, is there any news item which needs to be presented today? I hope that helps. If it's not clear please let me know. I really appreciate your help! You dont know how frustrated I am with this.
•
•
Join Date: Jun 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 1
Newbie Poster
I see it appears to be an issue with the data type in the database. What field type is beginDate and EndDate? I did something very similar with another application, and ran into issue with ACCESS dates and ColdFusion DateFormat... attempting to recall what I did or locate the code.
•
•
Join Date: Jun 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by Torch7
I see it appears to be an issue with the data type in the database. What field type is beginDate and EndDate? I did something very similar with another application, and ran into issue with ACCESS dates and ColdFusion DateFormat... attempting to recall what I did or locate the code.
Try USING #CreateODBCDate(Now())# instead of DateFormat.
|
•
•
•
•
•
•
•
•
DaniWeb ColdFusion Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
•
•
•
•
advertising apple blogging business community copyright crime development email environment firefox gaming google hacking hardware ibm internet ipod law legal linux malware marketing microsoft mobile mozilla myspace networking news red hat research satnav search security skype social networking software spam storage survey technology trends trojan tv ubuntu virus vista web windows youtube
- Previous Thread: code error
- Next Thread: Help with a search form/page
