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 Mike Lewis 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
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
312
sirnose1
sirnose1
cohan123
  • Locked
  • Question
page layout->page size, optimal for web
Replies
0
Views
244
cohan123
cohan123
FALCONSEYE
  • Locked
  • Question
Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!
Replies
0
Views
355
FALCONSEYE
FALCONSEYE
hifispin2015
  • Locked
  • Question
Creating a slect all button for A Multiple Slect HTML Form Field
Replies
1
Views
104
LyndonOHRC
LyndonOHRC
Klyphq
  • Locked
  • Question
cfqueryparam syntax issue
Replies
7
Views
115
cfSearching
cfSearching

Part and Inventory Search

Sponsor

Back
Top