I'm trying to build a simple query in UD with the PHakt extension.
It is as follows:

select * from tblTest where field.x is not null

How do I get mySQL to disregard the null entries in that field?! I still get everything pulled from the database. The SQL statement works fine with ASP. What am I doing wrong???

Thanks,
Bobby

I'm Beginning to See the Light

OK,

I finally figured out to exclude fields with no data. However, when I try to preview the page in the browser, I get a big fat error:

Parse error: parse error in c:\program files\apache group\apache\htdocs\women\tmp7zrs6o4323.php on line 10

Here's the code:
("SELECT * FROM Contacts WHERE FirstName Not Like "" ORDER BY FirstName;"

I imagine it has something to do with the double quotation marks, but I can't figure it out. It works fine when you test the SQL statement.

Help!!!

Bobby

I'm Beginning to See the Light

Can u post all your code at the top

Keith Slater

Change the double quotes in your SQL to single quotes.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Hey,

Thanks much! That was the problem, alright.

Bobby

I'm Beginning to See the Light