Search results for query: *

Hi, I've written the following query as a search on our site and for the most of it, it works quite well. The problem is it is behaving strangely in certain situations. The first query works perfectly: SELECT muzenbr, MATCH (title) AGAINST ('thunder crack') +MATCH (artist) AGAINST ('thunder...

Its a linux server with 1 and 1. I just want to use it purely as a MySQL server. Ive set up phpMyAdmin on the server and all that works fine. The server isnt firewalled in any way. Im actually trying to set up PHP Nuke another server so I just entered the host name as the MySQL servers IP...

Yeah the message I get is ERROR 2003: Can't connect to MySQL server on '217.160.220.247' Its as if theres a setting thats preventing remote connections.

Hi, Im trying to set up a server purely for MySQL use. The problem I have is I can connect to the database from Localhost but not from any other servers. I have got both localhost and % users in my users table. Any help would be greatly appreciated. Thanks Alby

Im trying to transfer a database from one server to another using mysqldump. Ive dumped the file on the first server and gzipped it, the problem is when copying it over to the other server it doesnt have enough memory to unzip the file. I have tried to dump the file without compression but for...

I have to MySQL databases set up on different servers. No matter what I try I cannot connect to either of them with any windows based clients such as MySQL adminstrator. Both databases have users that allow a connection from any where and I can connect to them between servers just not windows...

Thanks for your replys, Not sure how can I find out if im in binary mode? The MySQL versions are the same on both servers.

Hi, I have just signed up for a new server and am having a few problems transferring my files and database accross. Database I used the following command mysqldump -u tdba -p --opt townsend > backup.sql ( i have also tried this without the --opt command) I then transferred the file over to...

This is perfect Cheers Guys

Can anyone tell me how i can retrieve two fields from a list box i.e. post code and email. I need to use both bits of information for a query. Any help will be greatly appreciated. Thanks Alban

This has worked great. Thanks a lot Alban

I trying to set up a function that automatically sends an email using a certain text file as the body text. Its either this or if there is any way to insert line breaks. This is the code I am currently using. Function SendOrderEmail() MessageTxt = "Txt here" DoCmd.SendObject...

I couldnt get this working so I've just amended the query to create the new field from the last five digits and leave them intact in the old field. This way no data is being apended we are just creating a new field. Thanks a lot Alban

AA61EB30003798 AB13ID30005151 AB14SX30025736 AB37RD30007441 This is the format I originally had (Order Number) I created a second field Order No and using the code you provided spilt the above into two field as shown below Order Number Order No AA61EB300 03798...

Ive got all this working now except when the query is run the new field we have created becomes blank for all the records that were already in the table. If I get the new records to import into a seperate table is there any way of cutting all of the records from it and adding them to the...

This is great thanks a lot Alban

I am trying to output a text file from a report, I'm using the OutputTo command in a Macro. i need to know how set the date as the name of the text file being output. Any help would be greatly appreciated. Thanks ALban

I've got this working Ok but I cannot run this more then once. I need it to modify the new records everytime i import them. And is there anyway of getting it to change the data silently without the are you sure popping up. Thanks Alban

Its alright I didnt use it on the original file a made a copy to test it.

What code do I need to split the field in two Thanks Alban