Re: Data model for storing boolean expressions

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 391,971 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,157 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Data model for storing boolean expressions

•

Join Date: Sep 2007

Location: North Bay Ontario

Posts: 174

Reputation: trudge is an unknown quantity at this point

Rep Power: 1

Solved Threads: 20

trudge

Offline

Junior Poster

Re: Data model for storing boolean expressions

#10

Mar 11th, 2008

I'm about at the limit of any help I might be able to provide you. This is a very good exercise.

If you were to save the query verbatim, could you not then present it back to the user for editing? Obviously they must know the structure of the database or they wouldn't have been able to create the query in the first place. Your task would be to accept an edited query (properly sanitized) before executing it. An option to save the new query results might be available.

If you haven't yet done so, you may want to check the newsgroups - there are some good ones for database design, and that is where I first ran into Joe Celko. He actually responded to a query I had a few years ago.

Last edited by trudge : Mar 11th, 2008 at 5:39 pm.

Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"

DaniWeb Home > Forums > Web Development > Databases > Database Design > Data model for storing...

Re: Data model for storing boolean expressions

Data model for storing boolean expressions

Re: Data model for storing boolean expressions