my final 1064 error

Here is my final problem that I am struggling to overcome... SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate, Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID FROM Vouchers WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND ((DateDiff('d', [EndDate],Date()))<=0

1064 errors

Hi, I have several procedures that I have taken from an old Microsoft database, and I have tired to use them in a MySQL 5.1.32 database, but I am getting errors when trying to input them. There are three in total that I am struggling with and would appreciate some guidance... This is a cros

From MS Access to MySQL

I have taken a Microsoft Access database and have basically copied the structure of it and rebuilt it in MySQL, however, I have encountered some problems with formatting of data. I need to ask what is the most suitable field type to use to retain the content from Access field types The MS A

Does MySQL 5.1 store queries?

Until recently I have been using 4.0.25 and have just upgraded to 5.1 and just wondered if MySQL now enabled me to store queries in the database rather than have to put them all on my pages. Basically, I want to be able to write some select statements and save them in the database. Thanks

Securing MySQL on Mac OSX

I am in the process of installing MySQL and PHP on my Mac following instruction in a book written by a chap called David Powers. I have come to a section that is called 'Securing MySQL on Mac OSX'. Basically it states that MySQL is up and running with a default account of 'root' and it's no

Upgrading

Hi all, I am on... wait for it... version 4.0.25 and I want to upgrade to MySQL 5.x Is there anything special I should do in order to upgrade? Do I need to uninstall v4 or can I just download the most current version and double click to upgrade? I am not particularly hardcore mysql minded,

Connection failed!!

I have just loaded MySQL 5 and MySQL Front on to a new computer, and I am now getting a MySQL-Error which is: Connection failed: 1045 - Access denied for user 'root'@'localhost' (using password: NO) My Old pc has exactly the same settings but that uses MySQL 4 I have done a system restore to

Query problem

I am trying to display results from one or the other part of the query, however, at the moment it is showing results from both parts. The Replace part of the query works fine in that it chooses the correct data to display, but the content relevant to /8/ always displays even when I select,

I need to add to content somehow

I have a DB that has a field in it that currently just holds single or double numbers - these numbers are basically a reference to a category in which the particular record should be displayed. However I have now been asked if I can make it so that a particular record can be displayed in mo

SQL query problem

Hi, I have built a site with Dreamweaver and I have a problem with a query. I am trying to pass a parameter from one page to another to drill down. Basically, I have one product entry that is in multiple categories on my website. So, say it's a dress, it is therefore related to category 1

Select question

I've got this statement to select the last two entries in my db: SELECT top 2 * FROM Content ORDER BY ContentID desc and it works fine because it selects the last two items entered into the db. However, I only want to be able to select item 2 rather than both 1 and 2. How do I do that? Tha

Is this a permissions problem?

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 3.51 Driver]Access denied for user: '@localhost' to database 'client_db1' I am having trouble getting any MySQL site to work on my local PC, but they work fine remotely. I have just changed PC and now have IIS whereas before

Re: I am stupid>>

I had managed to land a job that required me to learn MySQL quickly. I was used to working with access though, so what I did was find a utility for access called MyAccess which enables you to work in access but you are actually affecting a MySQL db - it has a few funny things that could put you off

SQL problem

I have a home page where I need to show three news articles which are specified by the administrator - so it might not be the latest articles and they might not be in any order. I have designed the db to have two tables to fulfill this function the first table 'tbl_press' holds the news article

Timestamp plus 365 days

database or is it some clever sql - or both? Thanks Mat -- Matthew Stuart 11 Yew Tree Close Middleton Cheney Banbury Oxon OX17 2SU 01295 713813 07803 207734 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Create a date value 7 days from now

I assume the INSERT statement you have suggested goes on the webpage that has the form from which the new record will be created, Is that correct? Thanks. Mat On Saturday, February 7, 2004, at 02:24 PM, Roger Baklund wrote: * Matthew Stuart I am trying to get MySQL to automatically create a

Create a date value 7 days from now

I am trying to get MySQL to automatically create a date seven days from the date a new record is created. The new records will be inserted through an ASP, VBScript website. I have managed to get this to work in MS Access by typing in to its default field in the database Now()+7. As you would ex

Uploading database content with PHPMyAdmin

I have just started to use PHPMy Admin in the last hour or so. How do I upload the data and structure to a remote server. I have done a mysqldump and have tried to upload it but I keep getting an error. I create a statement in a window, browse to a file to upload it and submit the form. I wait

Re: Need DSN less help

The ISP do have the driver installed and they also know what they are talking about. The problem is they won't talk to me because I am not the reseller (ie their customer). The reseller I have used knows nothing about MySQL - he knows everything else but MySQL. Mat On Thursday, February 5, 2

Need DSN less help

I am having problems with making a connection between my website and the MySQL db on a different server. I have tried both hand coding and using the MyOLEDB application for MySQL. What am I doing wrong? If you think this looks a little strange, it is because it is a dreamweaver connection file.

LIMIT not working problem

This query is working fine apart from the LIMIT part. I can’t see what is wrong with it, I have tried it in different places and still no luck. Does anybody know why it’s not working? WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_c

Re: SQL select help required please

I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below code is giving me some ji

SQL select help required please

I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below code is giving me some jip

Time out problem

I have developed a website on my PC and I am testing there too. I keep getting script time out errors, can I stop this from happening? I am basically having to build an identical site and test it using access. Double the work!! I can't believe that access is responding tens if not hundreds of t

Re: Convert MS Access to MYSQL

On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote: There was some discussion in December of converting MS Access databases to Mysql and the DBManager program was recommended. I have recently converted access to mysql. I used access to import a CSV file and ensured all data was in

Performance problems

I have built a web site and I am testing it locally on my PC. Testing through Internet Explorer is awfully slow and most of the time I am getting error 'ASP 0113' script timed out. The table I am calling records from is quite text heavy (a few hundred to a 1,000+ words per field in some places)

Selecting by date

I have created a sql statement that enables me to select all entries in to MySQL that are dated today, I am trying to do the same for all items that are now one day old and also two days old etc I am doing this: SELECT * FROM table WHERE category = 3 AND show = 1 AND date = NOW()-1 I have it wo

Problem searching table

ASP and VB I have created a search web page searching a MySQL table with the following code: CREATE TABLE tbl_allarticles ( fld_ID mediumint(8) unsigned NOT NULL auto_increment, fld_category tinyint(2) unsigned NOT NULL default '0', fld_updateddate timestamp(8) NOT NULL, fld_createddate timesta

Importing a dumpfile

Right having just got to grips with the mysqldump command, I would like to be able to know how to import the database back in to MySQL should anything happen to my PC. Does mysqlimport have to be done in the command line window like mysqldump, and if so, how? It's just that I tried to import st

Re: Please help with syntax for mysqldump

command in the start menus run dialogue box: C:\Windows\Desktop> cd C:\mysql\bin and from there I have issued all commands in the black window. Is this not the command line, and if not, what is? Sorry for my ignorance, I am still a beginner. Mat -- Matthew Stuart

Please help with syntax for mysqldump

I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could somebody email me the full syntax to use which comes after the mysql> If I ca

Problems with a dump

I have tried two ways of dumping data but it doesn't seem to be working. One using the admin window with mysqldump dbname > dumptest.sql but I don't know if it has done anything because all it did was return to a new blank line. I can't find anywhere a file named dumptest.sql The other way was

Passwords query

I have been given these passwords for a MySQL db on a remote server. I have to dump the records to this volume on the remote and I am not sure what these passwords mean to me. SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER username_master password SELECT,INSERT,UPDATE,DELETE username_runtime pass

I'm using 4, host using 3!!!

I am using version 4 of MySQL and the people who I am told to use to host the site are running 3 on the server I will be using. I am not using any real complex table structures eg: autoincrement, date, timestamp, medium int, small int, indexes. I have to do a dump of data to install on remote s

Re: apostrophe error

Man I have been banging away at this for a week and I am only just getting to a point where I am finding a resolution. There seems to be a lot of info out there for this kind of thing, but very little on how to implement it. I use ASP and VBScript with Macromedia Dreamweaver so with asp I can

Escaping single quotes

I am on my first MySQL DB and it is very text heavy because it is a news site, therefore there is a great deal of use of the apostrophe or as MySQL would see it the single quote. I was hoping to be able to use double quotes to overcome the need to constantly have to escape the apostrophe/single

struggling newbie - datetime or timestamp problem

I have been sent a url for datetime explanations in the MySQL manual. I have learnt a few things, but I am also more confused than ever. I am trying to create a couple of columns (one createddate and one updateddate) in a MySQL table that are DATETIME or TIMESTAMP values, but I am having troubl

newbie FTP question

I have my website and MySQL db sitting locally on my PC. I need to get it to the remote server, I know how to get the website pages and images there, but am not sure how to transfer the data, tables and all from the database. Can somebody help me or point me to a tutorial? Thanks Mat -- MySQL

Importing dates from access

I have an access db with populated fields, some of them are date fields. One is a created date and another is a updated date. I haven't tried it yet, so I am not sure what I will get but I assume that if I am asking MySQL to automatically update these fields rather than manually have to fill th

Can I use TAB delimiters for importing CSV

Am I able to specify to somebody who is dumping from Oracle to use TAB as the delimiter? Does MySQL enable me to specify during import that the CSV is a TAB delimited file? What do most of you use that would not cause problems with text heavy dumps? Double quotes and comas etc are used through

Relationships

How do I create relationships between tables? I have tried but have no way of being sure that I am successful just by looking at the db. I am not sure how to relate one record in one table to it corresponding record in another. Mat -- MySQL General Mailing List For list archives: http://lists.

Escaping single quotes

rowser. I asume it is some sort of http:// based link as it would be for an image. Is there any special kind of formatting I have to do to the text file for it to show as html? TIA Mat Mat ------ Matthew Stuart 11 Yew Tree Close Middleton Cheney Banbury Oxon OX17 2

MySQL beginner - upload to remote confusion

mote site? Mat ------ Matthew Stuart 11 Yew Tree Close Middleton Cheney Banbury Oxon OX17 2SU 01295 713813 07803 207734 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]