Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cfqueryparam-testing for null

Status
Not open for further replies.
lwfg

lwfg

Programmer
Feb 9, 2009
52
0
0
US
If the where part of query is "where date1 is null", how do you redo it using cfqueryparam?
 
Sort by date Sort by votes
why do you need cfqueryparam at all?

[blue]WHERE columnname IS NULL[/blue] doesn't require any additional input

there's nothing to parameterize

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sirnose1
  • Locked
  • Question
CFIF for CFmail
Replies
0
Views
123
sirnose1
sirnose1
cohan123
  • Locked
  • Question
page layout->page size, optimal for web
Replies
0
Views
105
cohan123
cohan123
FALCONSEYE
  • Locked
  • Question
Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!
Replies
0
Views
149
FALCONSEYE
FALCONSEYE
hifispin2015
  • Locked
  • Question
Creating a slect all button for A Multiple Slect HTML Form Field
Replies
1
Views
52
LyndonOHRC
LyndonOHRC
Klyphq
  • Locked
  • Question
cfqueryparam syntax issue
Replies
7
Views
58
cfSearching
cfSearching

Part and Inventory Search

Sponsor

Back
Top