Zugg Software :: View topic

Beginner Joined: 30 May 2010 Posts: 18

I'm trying to extract entries from my database using:

DBSearchResults=%find(%i,Zone)

%i contains an existing entry in the Zone view, but I'm getting back zip. If i lose the Zone argument I will get back entries containing the keywords in %i. So the problem lies with the view argument. I'm probably doing something silly wrong, but can't figure out what. Who can help?

Beginner Joined: 30 May 2010 Posts: 18

So far i've disabled Views since nobody has an answer for me. I run into another problem then. If i use:

DBSearchResults=%find(%i)

and %i is an exact match to an entry in the database i don't get the entry back, but the first record in the database.

Any help on this?

Wizard Joined: 22 Mar 2007 Posts: 2320

I don't have an answer for you; I stopped using the internal database long ago. I suspect that's true of a lot of us. The only thing I have to offer is that you could use an external database such as SQLite. The newer functions %sql() and %sqldb() let you interact with an external database using standard SQL commands. The original plan was that the internal database would be upgraded in Cmud, but the new interaction with external databases makes that somewhat superfluous. The internal database is becoming a legacy of Zmud that few of us remember.

Beginner Joined: 30 May 2010 Posts: 18

Aaaah ok. Any tips on converting the content of the CMUD database to SQlite?

Wizard Joined: 22 Mar 2007 Posts: 2320

I would say, start from scratch. You can do so much more with a relational database, even a simplified one like SQLite, that you can't with the internal database that merely translating will severely limit your options. If you are actually going to use SQLite or some other SQL database, and you already know something about relational databases, I suggest that you completely rethink what you want to do with your database. Take advantage of the relationships you can build in the db.

On the other hand, you don't know anything at all about relational databases, we can probably make some suggestions on making a simple set of tables that work somewhat like your existing tables if you give us some details on what you have set up currently.