Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Substring within MATCH WHERE clause
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 -
Substring within MATCH WHERE clause
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... -
-
Update Table
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...- KingSlick
- Thread
- Replies: 3
- Forum: Microsoft: FoxPro
-
Escape a double quote in a string
Thanks for all the help. I think the best way is to use the chr(34). -SM- KingSlick
- Post #7
- Forum: Microsoft: FoxPro
-
Escape a double quote in a string
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- KingSlick
- Thread
- Replies: 10
- Forum: Microsoft: FoxPro
-
Scrolling to the top of a div
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...- KingSlick
- Thread
- Replies: 5
- Forum: Javascript
-
Resizing PDF output from CutePDF
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...- KingSlick
- Thread
- Replies: 0
- Forum: Microsoft: FoxPro
-
Delete duplicate records
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 -
Delete duplicate records
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 |... -
Delete duplicate records
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 -
Delete duplicate records
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... -
-
substr_count() case insensitivity
Is there any way to have case insensitivity while using the substr_count() function? Thanks in advance -SM -
-
A variable with the callback
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... -
Passing session vars
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... -
Lock on table
Sorry. From the tests that I ran on this, they continue to successfully lock the table. And returns a success message. SM -
Lock on table
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 -
Random selections
I kept trying RANDOM(). I knew it was something that easy. Thanks
