Digital Workshop

I am trying to create a query for all surnames beginning with a certain letter, I have setup the query and used the equal to with a Compare to String value..but what do I enter for all entries beginning with W?

var RecSet = db.ExecuteSQL("SELECT * FROM tablename WHERE fieldname LIKE '%"+mySearch+"%'")

The above will match any wildcard - EG if there is a W in the field.

Remove JUST the left % to match W at the start of the field.

Mack

This would solve a problem that I also have, but where and how would you use this script in opus?

As far as I can see you only have the option of using the SQL Wizard? or script in another window?

Hi Jez,

Not quite sure what your getting at...but I pull this example from a DB application that I use. Records are displayed on screen in array elements to create a list.

At the bottom is a search box, enter the term and click return passes this to a function that retrieves (select statement) the dataset based based on the filter. This dataset then populates the existing array - thus displaying my filter list.

Hope this helps.

Mack

Hi Mack

Thanks for the reply

I have been using the access database example that came with the software.

If I insert a new page before the example, insert a user text box, save this variable then add a search button (which is really a go to next page), then on the given example page I want to amend the query so that it takes the saved variable and adds a % before and after so that only the searched results are shown.

Task : amend access example to provide user with a search box.

I hope this makes sense.

for what I wanted I have just worked it out.

If anyone else wants to do this then a carry on from my last post...

On the second page where the results are shown, add a script to the page's action list that contains:


In this example V1 was from the first page (user input / search text) and V2 is a new temp variable.

We can now use V2 to search.

I hope this makes sense now.

That would work

Also don't know what you DB application is for, but if the search is an important function and you want flexability, then you could have the user include a wildcard.

IE they enter %ing% or %ing or ing% or simply ing

This would allow you to perform more specified searches, but would depend on your audinace and whether the understood the wildcard concept.

This may lead on to using the other SQL wildcards.

Mack,