trudge

From what I know, Shift-Refresh will force most Mozilla browsers to grab a new copy of a page from the server rather than cache.

Why are you asking about SQL Server 2000 in a MySQL forum? Wouldn't you expect a better response in a forum dealing with that product? And your subject heading is misleading.

On the topic of the link directory, I've submitted the link to my web site, and apparently it is supposed to be visible in my profile, as a thumbnail etc, but all I see is the link to it. Am I missing something.

At first glance the answer is 'store it as is in a varchar field'. But it seems you want to do something else. Perhaps if you gave us the context of this problem, it would suggest a design. What do you really want to do? Are these answers to questions? …

You may have to define 'character' a little better for your purposes. (Will you allow *?!@#$%^&()<>:;'~`)? But the following works, while a bit kludgy: [code] #! /usr/bin/perl use strict; use warnings; # Begin with a letter # 4-8 characters long # must include at least 1 digit while (<DATA>) { …

The error message indicates you haven't loaded a module, or the syntax you are using is incorrect for the 'time_passed' function. Have you installed the module 'Basic.pm' correctly? Read about Perl's %SIG hash - it is used for several signal functions. [code]$SIG{INT} = 'IGNORE';[/code] will ignore Ctrl-C

You might be on the right track for 3NF but I suggest you take a closer look at your overall design. You have a client table, but it is mostly populated with IDs for other client-related data. Why not just put all the client data into the client table? Your …

Depending on your version of MySQL there are a couple of ways to do this. Assuming a version of at least 3.23, you can do this [code] CREATE TABLE MyTable (seq INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY) AUTO-INCREMENT=300 [/code] If your table already exists, insert a fake record with …

The typical solution to this is not to save the image in the database, but the path to the image (or any large binary file for that matter). MySQL can handle binary data but it is hardly worth the effort getting it to work - the actual image itself can't …

I have code that successfully displays results, but throws an error in Fx 3 and IE 6. A sample of the XML file: [code] <?xml version="1.0" encoding="ISO-8859-1"?> <mycds> <cd> <title>Wolf City</title> <artist>Amon Duul II</artist> <artist_id>1</artist_id> <track_id>1</track_id> <sequence>1</sequence> <track_name> Surrounded By The Stars</track_name> <track_id>2</track_id> <sequence>2</sequence> <track_name> Green Bubble Raincoated Man</track_name> <track_id>3</track_id> …

Your data is probably fine, but it sounds like you may have to install the mysql server again.

How did you 'copy all the files over'? What versions of MySQL are running on your original host, and on your new host? There are a few things that can munge a migration, but knowing the answers to these 2 questions will give us a better idea of where to …

bcasp is pointing you in the right direction. As a further enlightenment, any time you ask yourself the question 'what if column X has more than Y choices' is an indication that that column should be broken out into a separate table.

What does your PHP query statement print out as? I'm betting it's not what you think it is. Also, a [code]describe images[/code] would help us help you.

It is generally more practical to save the path to the images in the database, rather than the images. This applies to any binary file. Let the OS file system take care of the files. If you save the images in the database you have just doubled the disk space …

Why not just access the database using the 'mysql' client side program? [code] mysql -hwww.yourwebsite.com -uyourusername -p [/code] This will prompt you for the password. Once you are logged in you have direct access to the database. Unless of course the admins have not granted permissions to access from remote. …

These don't look like any ER diagrams I've seen, but anyway. What do you mean by 'it shows the opposite'? What SQL query have you used to show you anything? YOU make the relationships between tables, not some diagram.

I notice you have some non-standard characters in the query. You might be trying to match something from one character set to something in a different character set. [code] WHERE annons.område=områden.id [/code] Make sure the correct character set (and same character set) is enabled for the whole database, each table, …

What have you got so far?

This is good advice. Whenever you have a field / column with multiple values that's a clue to pull it out and put it in a separate table.

I'm not sure what you mean by 'FE' or 'BE', but if you are planning on mounting this database on a web server I suggest you forget about using Access. Actually Access is not even the database, but Microsoft's front-end to their JET database. It is not designed for multi-user …

You can't 'display' an image in an email. You can however attach a file to an email and send that. However that is not a MySQL topic. You would be better in a forum for the language you are using to do this in.

Is this any help? [url]http://dev.mysql.com/tech-resources/articles/wizard/index.html[/url] [url]http://www.tek-tips.com/viewthread.cfm?qid=1289414&page=1[/url]

Can you not use the \G switch? [code] select * from customers \G [/code] This displays the field names vertically instead of across the top. At least in 5.* it does. Otherwise you will have to play with your window size / font size.

Where have you looked? The Perl FAQ that comes with every Perl distribution contains 'How can I lock a file?' I suggest you start there.

First I suggest you sit down with a good book on relational database design ('Database Design For Mere Mortals' by Michael Hernandez and 'MySQL' by Paul DuBois come to mind). We can help you help yourself, but can't do your work for you.

Try to get in the habit of putting [code] use strict; use warnings; [/code] at the start of your scripts and it will save you a lot of frustration and time later on. Also, if you ever post to comp.lang.perl.misc, you will get flamed or ignored if you don't do …

Well, you sort of have the right idea with primary keys and foreign keys. But really what you need is to get a good handle on design. I'm not familiar with that book, but if you can get your hands on 'Database Design For Mere Mortals' by Michael Hernandez, it …

You might want to investigate indexing.

From your description, blater's solution will do what you want. If you want to 'delete' a record, why move it to another table - just delete it. However for some reason you want to retain the data, but not display it, so just add another field for 'Display' and set …

What command did you try to execute? Copy and paste exactly what is on your command line, and the resulting screen.

Your design seems to be well on the way to what you want. In your 'Job Task Table output' you might want to replace the task ID with what the actual task is, unless you can remember what a task_id of 1 (or 3, or 7, ...) is etc. Remember …

I'm confused. Are you asking for help with MySQL or an HTML editor called InnovaStudio? We can only help you with MySQL questions here. With that in mind, you say that [quote]does not have any sql or connection to a db on it[/quote] So if there is no connection to …

Unless your company plans on saving the order data for future use, a database is not necessary for this. Which is not to say you shouldn't log attempts to log in with date/time stamp, IP address, domain name, attempts, etc. You may also have to add a CAPCHA image. A …

It is generally not a good idea to include markup in your data.

Your tables suggest you may need to do some more work on RDBM design. You have features and attributes of Products spread throughout several tables, when I believe they could all be in one table, with the appropriate fields. You want to try and collect all information about a thing …

[QUOTE=mexaros;555776]ok, so here is what i type: mysql echeck < c:/Program Files/Apache Software Foundation/Apache2.2/htdocs/admin/echeck.sql -uMYSQL-ROOT -p where "root" is a valid user in my mysql. I recieve the error: [B]ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …

If you mean you want to only display X number of results per web screen, then use the 'LIMIT' command in your SQL query. [code] my $sql=SELECT id, name, url FROM free_dirs LIMIT 25; [/code] Then you will have to programmatically add buttons to move forward or backwards through the …

Not sure you mean by 'entry'. But your first choice seems about right. You will want a table with the following fields: ID Company # bedrooms Price Then a user could select from your db where company=x AND #bedrooms = y AND price <= z Of course if you want …

I'm sorry this doesn't make any sense to me. The only 'putty' I know of is a free SSH, Telnet and Rlogin application for Windows. You seem to be asking about placing an image in a web page, which is not perl but HTML. Am I missing something here? What …

I was just reading about programming and SQL logic, and how they are different. ('Data & databases: Concepts in practice' by Joe Celko). He explains the difference between programming logic and SQL logic. For a programmer, logic is used to make decisions about sequential control. In SQL, logic makes a …

I'm not sure how VFP works internally, but a move to .NET should be viewed with caution. My experience with databases is limited to MySQL and I have never come across a situation where it will not perform amazingly. Visit their site to see what companies are using it - …

I've mentioned SQL Injection attacks a few times in this forum and the Database Design forum. From the responses I got, many folks here don't know what an SQL Injection attack is. If you do any SQL interaction via a web-based interface, do yourself and the Internet community a favour …

Generally, you want to create tables that consist of data about one particular object or transaction. I don't know if there is such a thing as 'too many' relationships. The design of your database is driven by your need to access the data in certain ways. In this case, I …

Whenever you have a field with multiple values, it is a good indicator to create a new table for that data. In this case, use the ID field to tie former names to each other. Split the query result on the comma, strip off leading/trailing spaces, and insert what's left …

If you want to learn MySQL just start doing it. Find a good book or tutorial and build your own database from scratch. I don't know of any 'canned' databases to download. And any I've ever made are not for sale :)

'Large' is relative as is 'optimize'. There are lots of MySQL databases handling millions of records / transactions. You can use EXPLAIN to see what your queries are actually doing. Why not wait until you notice a severe reduction in query time, then see if anyone here can help.

Re-entering data is the *last* thing you want to do. In your case, it sounds like you have all the data you need in an Excel sheet, but need to get it into a database of some kind. You may need to get a programmer to parse through your exported …

Show us what you have tried so far. You should ALWAYS sanitize user-supplied data before doing a SELECT to avoid SQL injection exploits.

How are you choosing Position? If that is generated by the server, then it is guaranteed to be unique.