Skip to main content
A
Anonymous
April 18, 2008
Answered

Missing Operator

  • April 18, 2008
  • 3 replies
  • 866 views
Hello~

I am having some problems with an Update query. I have another query just like it on another page that works fine, and I don't know where I am going wrong-- I'm sure it's punctuation or something, but I can't find it. Please help!
This topic has been closed for replies.
Correct answer MichaelSJudd
I would say that nothing is making it back from the getID query.

Use some <cfif> statements to find out, like

...
<cfif getID.RecordCount GT 0>
...run the fileContent query...
<cfelseif getID.RecordCount EQ 0>
...do some logic, alert me, or my favorite - just do nothing...
</cfif>

- Mike

3 replies

M
MichaelSJudd
Inspiring
April 18, 2008
Oh yeah - and there were no single quotes around #getID.WritingContests_ID#.

- Mike
M
MichaelSJuddCorrect answer
Inspiring
April 18, 2008
I would say that nothing is making it back from the getID query.

Use some <cfif> statements to find out, like

...
<cfif getID.RecordCount GT 0>
...run the fileContent query...
<cfelseif getID.RecordCount EQ 0>
...do some logic, alert me, or my favorite - just do nothing...
</cfif>

- Mike

A
Anonymous
April 18, 2008
There shouldn't be single quotes because it's a number field, but there was a problem with the passed in value! It was from another query, and I fixed it. Thanks!
H
Hydrowizard
Inspiring
April 18, 2008
the url here part -add your url
A
Anonymous
April 18, 2008
On my actual page it is there, I just put (URL HERE) for security purposes.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices