3 cfquery Updates

[Guest]

I have a template that updates 3 database tables with three different cfquery update statements. For some reason the second 2 are not updating the data specified by the query. Here is a look at the code.

<CFQUERY NAME = "SubJob" datasource="#REQUEST.DataSource#">
UPDATE SubJob
SET SubJobNumber = '#FORM.SubJobNumber#',
Project = '#FORM.Project#',
PONumber = '#FORM.PONumber#',
OriginalPOAMT = '#FORM.OriginalPOAMT#',
WONumber = '#FORM.WONumber#',
AccountNumber = '#FORM.AccountNumber#',
PreparedBy = '#FORM.PreparedBy#',
ProjectEngineer = '#FORM.ProjectEngineer#'
WHERE SubJobNumber = 'N' AND
JobNumber = '#URL.JobNumber#'
</cfquery>

<CFQUERY DATASOURCE="#REQUEST.DataSource#" name="SubJob1">
UPDATE Productivity
SET SubJobNumber = '#FORM.SubJobNumber#'
WHERE SubJobNumber = 'N' AND
JobNumber = '#URL.JobNumber#'
</CFQUERY>


<CFQUERY DATASOURCE="#REQUEST.DataSource#" name="SubJob2">
UPDATE CostJobApproval
SET SubJobNumber = '#FORM.SubJobNumber#'
WHERE SubJobNumber = 'N' AND
JobNumber = '#URL.JobNumber#'
</CFQUERY>

[BKBK]

For some reason the second 2 are not updating the data specified by the query.
There is no apparent reason for them to fail. How do you know the first works and the last two don't? Add the following code at the end and verify the result in the dumps:

<CFQUERY DATASOURCE="#REQUEST.DataSource#" name="SubJob3">
SELECT SubJobNumber
FROM Productivity
WHERE SubJobNumber = '#FORM.SubJobNumber#'
AND JobNumber = '#URL.JobNumber#'
</CFQUERY>

<CFQUERY DATASOURCE="#REQUEST.DataSource#" name="SubJob4">
SELECT SubJobNumber
FROM CostJobApproval
WHERE SubJobNumber = '#FORM.SubJobNumber#' AND
JobNumber = '#URL.JobNumber#'
</CFQUERY>

<cfdump var="#SubJob3#">
<cfdump var="#SubJob4#">

[BKBK]

Forget it. Just noticed that you posted all over the place. Please, don't do it. You wont get three times as many reactions that way.

[Newsgroup_User]

> UPDATE Productivity
> SET SubJobNumber = '#FORM.SubJobNumber#'
> WHERE SubJobNumber = 'N' AND
> JobNumber = '#URL.JobNumber#'

I presume it's because that filter doesn't match any reocrds in that table.

You might want to do a Google search on "SQL injection attacks" as
motivation for getting <cfqueryparam> tags on all your dynamic values,
ASAP.

--
Adam