ruba Posted August 7, 2007 Share Posted August 7, 2007 I have a data driven website connected to a FileMaker Pro 8.5 database. In my webform, I have a few dropdowns and textboxes. The problem is that there are lots of empty fields in the database, so no matter what the user is going to enter, the search is not returning any data. So with one NULL in the queryString, no data will be returned. Does anybody know the syntax of how to handle NULLs in a queryString? I know in Oracle there's the NVL function: NVL(value,NULL) it returns "value" and SQL Server it's ISNULL(value,null), it returns "value". I'm not sure what's FileMaker's syntax...I tried both and of course didn't work... any help would be really really appreciated!! thansk Link to comment Share on other sites More sharing options...
The Shadow Posted August 8, 2007 Share Posted August 8, 2007 I don't know if this will work with FileMaker, but the SQL-92 standard uses: COALESCE(v1,v2) which the standard says is shorthand for: CASE WHEN V1 IS NOT NULL THEN V1 ELSE V2 END so you might try one of those two. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6234 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now