Skip to main content
N
Newsgroup_User
Inspiring
July 23, 2008
Question

Getting everything but empty fields in MySql query

  • July 23, 2008
  • 3 replies
  • 453 views
I was trying to get all users email addresses that actually have a email
address entered in the database. I tried:

<cfquery name="AllUsersCSV" datasource="SalleBoise">
select #form.sql#
from inforeq
where #Search1#=<cfqueryparam cfsqltype="cf_sql_smallint" value="1"> <cfif
form.sql eq "Cust_Email">and Cust_Email not ''</cfif>
</cfquery>

But kept getting a "You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '''' at line 3" error

What would be the 'proper' way to search for these records?


    This topic has been closed for replies.

    3 replies

    N
    Newsgroup_UserAuthor
    Inspiring
    July 23, 2008
    Thanks Dan, the <> worked just great......

    "Dan Bracuk" <webforumsuser@macromedia.com> wrote in message
    news:g67ofl$j26$1@forums.macromedia.com...
    > Your specific error comes from the word "not". It should be either <> ",
    > is
    > not null", or both, depending on how you store your data.
    >
    > There may be some other issues, depending on what the values of form.sql
    > and
    > Search1 are.
    >
    >
    >


    -
    -__cfSearching__-
    Inspiring
    July 23, 2008
    Steve Grosz wrote:
    > Thanks Dan, the <> worked just great......

    The on-line MySQL documentation can also be very helpful for syntax problems or questions
    http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_not-equal
    S
    satheesh_p
    Inspiring
    July 23, 2008
    You can print your SQL statement and copy the statement and execute it in SQL. This way you can easily figure out the problem.

    Hope the above helps.
    Thanks,
    Satheesh.
    D
    Dan_Bracuk
    Inspiring
    July 23, 2008
    Your specific error comes from the word "not". It should be either <> ", is not null", or both, depending on how you store your data.

    There may be some other issues, depending on what the values of form.sql and Search1 are.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices