Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'rd_mwv'.
|
| |
The error occurred in C:/HostingSpaces/foodiead/foodieadventuresmwv.com/wwwroot/includes/inc_qry/inc_qry_bus_listing.cfm: line 54
|
52 : OR
53 : ( b.PageID = 10 AND d.MemberType = N'member' AND d.DuesType <> 'associate' )
54 : <cfelseif bvid eq 3>
55 : ( b.PageID = 6 OR ( b.PageID = 3 AND d.MemberType = N'member' AND d.WebException = 'yes' ) )
56 : OR
|
|
| EXCEPTIONS |
<small><i>not set</i></small> |
| DATASOURCE |
rds_mwv_2016 |
| SQL |
SELECT
a.subcategoryname,
b.categoryname,b.seocategorydirectory,
d.bv,d.companyname,d.directlink,d.ct,d.cv,d.description,d.directions,d.duestype,d.ecofriendly,d.emailaddress,d.featured,d.fv,
d.giftcertlink,d.gpscoordinates,d.gv,d.hours,d.jv,d.mailzip,d.memberid,d.membertype,d.menu_link,d.nc,d.ncv,d.nightlife,
d.petfriendly,d.phone,d.physaddress,d.physcity,d.physstate,d.picture,d.prephone,d.pretoll,d.price,d.resurl,d.se,
d.secondweblinkdesc,d.secondweblinkpath,d.seomemberfilename,d.seostatedirectory,d.showmailaddress,d.specials,d.textblurb,
0 as feat_count,
d.tollfree,d.valleyoriginal,d.videocode,d.webaddress,d.webexception,d.weblink,d.worldres,d.worldresid
,b.categoryid,b.pageid,a.subcategoryid
FROM tbl_Types_Members_SubCategory as a
INNER JOIN tbl_Types_Members_Category as b ON a.CategoryID = b.CategoryID
INNER JOIN tbl_Members_MemberCategory as c ON a.SubCategoryID = c.SubCategoryID
INNER JOIN tbl_Members as d ON c.MemberID = d.MemberID
WHERE
( b.PageID = 2 AND d.MemberType = N'member' AND d.WebException = 'yes' )
OR
( b.PageID = 2 AND d.MemberType = N'member' AND d.DuesType <> 'associate' )
ORDER BY b.CategoryName, a.SubCategoryName, d.CompanyName |
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
216.73.216.33 |
| Referrer |
|
| Date/Time |
06-Jul-25 06:07 PM |
|
|
Stack Trace
|
at cfinc_qry_bus_listing2ecfm902138452.runPage(C:/HostingSpaces/foodiead/foodieadventuresmwv.com/wwwroot/includes/inc_qry/inc_qry_bus_listing.cfm:54) at cfdining2dnightlife2ecfm570664321.runPage(C:/HostingSpaces/foodiead/foodieadventuresmwv.com/wwwroot/visit/dining-nightlife.cfm:14)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'rd_mwv'.
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:758)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.base/java.lang.Thread.run(Thread.java:833)
|
|