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

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

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

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

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 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 need my table to automatically insert todays date in the follwing format. 130503 Any help would be GREATLY appreciated. Alban

I am trying to write a module that will automatically remove the first 9 characters of a fourteen digit record and just leave the last 5. Any help would be greatly appreciated. Thanks Alban

Can someone please help me I need to export some data from a table into a text file. The problem is it needs to be in the following format: 0[Field 1] [Field2] [Field 3] 1 9[Field 1] 1 Field 2 is the date, i need the module to export all records with a certain date. Any help would be...