Re: SQL question

During development a useful couple of lines of code are, assuming you've been through your repeat for each col_name loop to create your query with it's many OR conditions: put tQuery into tTemp replace comma with cr in tTemp replace " OR " with cr & " OR " in tTemp --replace " AND " with cr & " AN

Re: SQL question

Hi Peter, Am 19.09.2012 um 18:21 schrieb Peter Haworth : > On Wed, Sep 19, 2012 at 3:07 AM, Klaus on-rev wrote: > ... >>> Klaus, have you implemented a solution to this yet? I don't recall you >>> mentioning which flavor of SQL you're using and that makes a difference. >> ah, sorry, I will use a

Re: SQL question

I wrote a function that did that. You pass it a comma del list of column names, and it builds an sql statement for you. I will try to dig that up somewhere. Bob On Sep 19, 2012, at 9:21 AM, Peter Haworth wrote: > I implemented exactly the same functionality in a name/address search db > once

Re: SQL question

On Wed, Sep 19, 2012 at 3:07 AM, Klaus on-rev wrote: > Hi Peter, > > Am 19.09.2012 um 07:40 schrieb Peter Haworth : > > > I'm not sure that will work. If Column2 started with "MyCriteria", I > don't > > think it would be selected. Any queries of the form LIKE '%mycriteria%' > > would work though

Re: SQL question

Don't know why that would be Mark. I simply reply to messages I get from the list. I guess if the original message was sent to the old and new address then my reply would be too. When sending new messages, I send to use-livecode@lists.runrev.com. Pete lcSQL Software On

Re: SQL question

Hi Peter, Am 19.09.2012 um 07:40 schrieb Peter Haworth : > I'm not sure that will work. If Column2 started with "MyCriteria", I don't > think it would be selected. Any queries of the form LIKE '%mycriteria%' > would work though. using wildcards is not my problem ;-) > Klaus, have you implemen

Re: SQL question

On 09/19/2012 11:37 AM, Mark Schonewille wrote: Pete, I get all your messages twice. Could you please stop sending copies to the old address of this list? A bit like Sesame Street's "Vincent Twice", nicht? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineeri

Re: SQL question

Pete, I get all your messages twice. Could you please stop sending copies to the old address of this list? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Use Col

Re: SQL question

Hi Mark, I think one way to do this would be: use the 'SHOW Columns' SQL command ie, SHOW Columns from Table Then put the column names into an array using revDatabaseColumnNames Cycle through the array and use a SELECT command for each element - Andy Piddock My software never has b

Re: SQL question

I'm not sure that will work. If Column2 started with "MyCriteria", I don't think it would be selected. Any queries of the form LIKE '%mycriteria%' would work though. Klaus, have you implemented a solution to this yet? I don't recall you mentioning which flavor of SQL you're using and that makes

Re: SQL question

Peters way seems like it would be quicker, although more work to implement, because it keeps an index of the columns you want to search for up to date. For a large table this would be the way to go. For a smaller dataset, you could probably get away with Mike's solution of using the concat() fun

Re: SQL question

Hi Pete, Am 17.09.2012 um 18:41 schrieb Peter Haworth : > Hi Klaus, > ... > > SELECT * FROM Index WHERE Table='Persons AND Text LIKE 'sa%' JOIN Persons > on Person.=Index.Key > > If you are using SQLite, your could use Triggers to keep the Index Table up > to date with any inserts, updates, or

Re: SQL question

Hi Mike, Am 17.09.2012 um 18:38 schrieb Mike Bonner : > Might look here. > http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103033 Theres an > example for locating an exact match that is simple, another > example that uses like, but not sure you'd want to mess with it. (seems to > be a convoluted

Re: SQL question

Hi Klaus, Don't think you cand o that with standard SQL tables. You can do it with SQLite Full TExt Search tables It could also be done with standard tables as follows. Set up an index table with columns named table, text, and key. In your example, every time your Persons table is updated, you w

Re: SQL question

Might look here. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103033 Theres an example for locating an exact match that is simple, another example that uses like, but not sure you'd want to mess with it. (seems to be a convoluted way to use 'or') I also found this, --select * from contacts whe

Re: SQL question

Hi Mark, Am 17.09.2012 um 18:25 schrieb Mark Schonewille : > Hi Klaus, > > The easy way to do this is to retrieve all column names, use a script (PHP or > LiveCode) to create the syntax for searching all columns with OR statements > and use another statement to retrieve the data with your now

Re: SQL question

Hi Klaus, The easy way to do this is to retrieve all column names, use a script (PHP or LiveCode) to create the syntax for searching all columns with OR statements and use another statement to retrieve the data with your now dynamic SQL syntax. MySQL has no built-in way to do this. -- Best reg