Recent content by KingSlick

Well I am getting the same error by making those changes. Is it possible to even include a substr within the match portion of the query? -SM

Hi, I have a search query that is working well. The query is using "MATCH (fields) AGAINST ($keywords IN BOOLEAN MODE)" in the WHERE clause. I need to have the search query only search about half of the field. I was thinking I could use SUBSTR within the MATCH portion of the field. As noted...

Thanks very much. That is working great!!!

Hi, I have created a form that reads in the memo fields of a VFP table so that it may be updated. I compile/build the project that contains the form into an .exe file, and run the exe. The exe loads, however, when I try to update the table I get the following error... Cannot update the...

Thanks for all the help. I think the best way is to use the chr(34). -SM

Hello, I am trying to escape a double quote character (") in a string. For example, strQuote = "Scott said "Hello World. It's Mine" to everyone" I also need to have a single quote within the same string. Thanks in advance -Scott

Hello, I have a div that I need to be a certain size. However, most of the time, there will be an overflow scroll. Within this div, I have other hidden divs. These hidden divs will be displayed on an "onClick" event. However, these same div will then be hidden again when another onClick...

Hello, We currently have a FoxPro project that takes a VFP table and then uses Ghostscript/CutePDF to create a PDF file. We have an .FRX report that is used to create the output then ghostscript sends the report output to CutePDF and is converted to a PDF file. This PDF is 8.5" x 11". We are...

Yes all the records will have a unique code field. I have corrected the problem. I just deleted everything with an id greater than that of where the problem started. But thanks for all of the help anyways. SM

I have an update script that adds them to the table. There was a problem with the script and had to be restarted. This caused the duplicates to be added again. So they are semi-scattered. An example is below. As you can see, the id is the primary key. ____________ |id | code |...

Ooops. Sorry. What I meant was the primary key is the only field that is different. Either of the duplicated records can be deleted as long as there is only 1 remaining. Thanks

I have a table that contains over 100k records. The problem that I have is there are about 5k records that are duplicates. All of these records are duplicated twice and the only field that is the same is the primary key. Is there any query that I could use that will only delete one of each of...

Great thanks -SM

Is there any way to have case insensitivity while using the substr_count() function? Thanks in advance -SM

Thanks Greg. This is working great.