[wdvltalk] Re: MS SQL Database

2003-03-17 Thread Amrit Hallan
Yes David. I've been extensively using MySQL. After running "mysqld" and then "mysql" I have been able to run all SQL commands and I'm familiar with query commands. It's only that, in this case, where to give those commands? I have MySQL installed on my machine, but not MS SQL. Amrit Hallan ¤¤

[wdvltalk] Re: MS SQL Database

2003-03-17 Thread Shashank Tripathi
Amrit, Not sure if your question was about MySQL (which you mention in your post) or MS SQL (as mention in the subject). Both are different databases. I'll assume you need help with MySQL. Let me know if this is totally off mark. At the hosting server, do you have PHPMYADMIN? If not, you may w

[wdvltalk] RE: MS SQL Database

2003-03-17 Thread Linden, Todd
Amrit, Are you using the Enterprise Manager? If so, simply go to your new database, expand it so you can see all the components of the database (tables, views, stored procedures, etc...). Then right click on 'Tables' and select 'New Table'. If you are more comfortable with SQL, you may want to

[wdvltalk] RE: [DTS] Access 97 to MSSQL 2000 headache

2003-03-17 Thread Furry, Tim
Stephen wrote: I am porting over some information from an Access 97 DB to MSSQL 2000 and am using scheduled DTS (data transformation services) to do it. Problem: on the first run, it creates the table fine, but when executing manually or on a schedule, it does not update the existing table... Th

[wdvltalk] Re: Access 97 to MSSQL 2000 headache

2003-03-17 Thread Furry, Tim
Eddie wrote: When I'm on tour I create article and Pictures. They are stored in a mySQL DB. When I want to update this DB I will not connect directly to the mySQL DB on the Server as this would cost me to much (over Satellite). So I was thinking on following option. Step 1: I'm creating with Acces

[wdvltalk] Re: MS SQL Database

2003-03-17 Thread Mark Groen
On March 17, 2003 at 1:33, Amrit Hallan wrote: > create a "database" and not individual table. Not an M$sql person myself (MySQL+php here), but once you create or name a database, then the next window should give you more options in regards to creating sql statements and adding tables with some

[wdvltalk] swf file

2003-03-17 Thread Joseph Harris
Someone has sent me an .swf file.It wouldn't play. I have downloaded uninstall then flash player version 6 from Macromedia and followed all instructions. The file still won't play; I am asked for an association but neither flash nor macromedia appear to be in the list. Has anyone any ad

[wdvltalk] Re: swf file

2003-03-17 Thread Joseph Harris
Additionally --- I have also downloaded Shockwave 8+ and have tried to associate through 'other'.Absolutely nothing. the only possibility might be that I have IE 5.0. Does it need a later version, or is there something else? Joseph > Someone has sent me an .swf file.It wouldn't play.

[wdvltalk] Re: swf file

2003-03-17 Thread Brewnetty \(AuntySpam\)
viruses can be disguised as .swf files. I hope your anti-virus software is up to date - Original Message - From: "Joseph Harris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 17, 2003 6:30 AM Subject: [wdvltalk] swf file Someone has sent me an .swf file.It wouldn't

[wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table

2003-03-17 Thread Paul Larue
Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT