Search results for query: *

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...

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...

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...

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...

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

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...

I am trying to select a certain number of records out of a table. The catch is that I want the records to be chosen at random. Is there a way in mysql that would allow me to a random selection? Thanks in advance -SM

I have a .swf that I am able to embed into my webpage, however, I am trying to add the "flash player" (the start, stop, pause, rewind, FF , etc.). I have a "skin" that has all the buttons I need but I can't seem to it to become part of the video

Is it possible? and if so, how?

Ok, I have a .dbf that I would like to delete some records out of it. The problem is that I need for it to remove based on several different strings that appear in the different fields. I have the following below that keeps giving me errors... delete for LOWER(laSortingOrder[zz,1]) $...

Ok, I have a web page that I have some video as part of it. Whenever you go to the page, the video must be downloaded to the browser's cache before it will begin to play. Is there any way to have it start playing before it is fully downloaded? Thanks in advance

I have a php script that has been running fine for quite some time, however, the past few times that I have run the script, I am no longer getting output to the browser and the script is finishing just fine. I haven't made any changes to the script. FYI, the script usually runs for about 10-15...

I am using AJAX to remove selections from a DB. These selections are listed inside of a <select> box. I am able to remove one sleection at a time, however, I am trying to be able to remove multiple selections at a time. See code below... function removeCompany(profile, selBox) { if...

I am using AJAX to remove selections from a DB. These selections are listed inside of a <select> box. I am able to remove one sleection at a time, however, I am trying to be able to remove multiple selections at a time. See code below... function removeCompany(profile, selBox) { if...

Ok, I am working with PHP and Ajax. I am trying to have an Ajax call add some text into a MySQL DB. The adding to the DB is working fine, however, the page is refreshing everytime and I don't want it to refresh. I am using the onMouseDown to start the call <input type="image"...

ok, I have a text box that has some AJAX search_suggest built into it. When you click on a suggestion, the text box is populated with the suggestion that was clicked and the focus is also sent back to the text box. However, it is going to the begining of the text and I would like for it to go...