Search results for query: *

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.

I have a small script to update a page using AJAX. Basically, it is to update the information of the customer when the blur off a text field. The question is, I have about 10 fields that could possibly be updated. So, is it possible to write one function that would work for all of the fields...

I am wondering if there is a way to pass a session variable through to different virtual subdomains. Right now, I am using $_SESSION[userID], this is the variable that is used throughout the site meaning that a user is logged in. Now, I have a subdomain setup and want to be able to have the...

Sorry. From the tests that I ran on this, they continue to successfully lock the table. And returns a success message. SM

At worse, you would need to use a mysql command line (ie. telnet or SSH in) and "UNLOCK TABLES;" This is about all you would need to do

I kept trying RANDOM(). I knew it was something that easy. Thanks