24. januar 2005 - 15:55
#4
så er du nok all set
men ellers prøv:
CREATE TABLE tblperson (
person_id INTEGER NOT NULL,
person_firstname VARCHAR(25),
person_lastname VARCHAR(25),
PRIMARY KEY (person_id)
);
INSERT INTO tblperson VALUES(1,'Anders','Andersen');
INSERT INTO tblperson VALUES(2,'Børge','Børgesen');
INSERT INTO tblperson VALUES(3,'Christian','Christiansen');
INSERT INTO tblperson VALUES(4,'Anders','And');
INSERT INTO tblperson VALUES(5,'Carl','Christiansen');
INSERT INTO tblperson VALUES(6,'Søren','Sørensen');
INSERT INTO tblperson VALUES(7,'Anders','Andersen');
INSERT INTO tblperson VALUES(8,'Børge','Børgesen');
INSERT INTO tblperson VALUES(9,'Carsten','Christiansen');
INSERT INTO tblperson VALUES(10,'Z','Zzzz');
SELECT a.person_firstname, a.person_lastname, a.person_id, b.person_id
FROM tblperson a, tblperson b
WHERE a.person_firstname=b.person_firstname AND a.person_lastname=b.person_lastname AND a.person_id <> b.person_id;
DROP TABLE tblperson;
25. januar 2005 - 12:19
#5
Hmm. Arne, man kan desværre ikke importere SQL filer eller SQL tekster.
Jeg har impoteret min database med et program og alt er også oprettet i serveren nu :)
25. januar 2005 - 12:27
#7
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=databas; UID=; PWD=;"
SQL = "SELECT * FROM anv WHERE anv = '"&namn&"' AND Los = '"&losen&"' "
set RS = Connection.Execute(SQL)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
/tjek.asp, line 16