why????....

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 423,554 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 3,799 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.

Join our community!

Please support our ColdFusion advertiser: Programming Forums

Thread Tools Display Modes

Views: 532 | Replies: 1

Previous Post in Thread

Next Post in Thread

•

Join Date: Dec 2007

Posts: 2

Reputation: ccrevling is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ccrevling

Offline

Newbie Poster

why????....

Dec 31st, 2007

I am a php coder and my work has asked me to take a look at why there is a problem with a site that is in cold fusion and php. So i said ok. Now im in a pickle i cannot figure out how to solve this problem. So here is the problem:

ok so this website pulls information from like 8 tables in one database. Now when i go to the 349-368 reportgenId rows it pulls up nothing. I have already checked php my admin and they are def. in there still. So the page loads if it is anywhere past or before those pages. Why would it just not let like 20 rows not show up? There are 2 pages that have this problem one that is in php and one that is in coldfusion. Now since the problem is persistant in both pages then im sure its the db but i have checked that as well and cannot find out what the hell is wrong with it.... If someone can help me that would be wonderful.
Here is some code.

Help with Code Tags

(Toggle Plain Text)

<CFQUERY NAME="Recordset1" DATASOURCE="mcss">
SELECT *
FROM mcss.requested_reports, mcss.gen_report, mcss.clientinfo, mcss.applicant_investgate, mcss.conviction_history, mcss.education_degree_verify, mcss.employment_verification, mcss.professional_credential_verify
WHERE mcss.gen_report.GenReportId =#URL.ReportID#
AND mcss.requested_reports.ReportID = #URL.ReportID#
AND mcss.clientinfo.clientID = mcss.gen_report.GenClientID
AND mcss.applicant_investgate.investID = #URL.ReportID# 
AND mcss.conviction_history.ConID= #URL.ReportID#
AND mcss.education_degree_verify.ED_ID= #URL.ReportID#
AND mcss.employment_verification.EmployID= #URL.ReportID#
AND mcss.professional_credential_verify.Pro_ID= #URL.ReportID#</CFQUERY>

The query information.
Now i have done an if statement that detects if it finds the URL.ReportID and it does so ya...
Why would it doe this???