28. juni 2007 - 14:39Der er
9 kommentarer og 1 løsning
Query giver fejl
INSERT INTO Member (loginName,createDate,password,lastName, street,city,state,zip,email,phone,fax) VALUES (“bigguy”,”2001-Dec-2”,”secret”,”Smith”, “1234 Happy St”,”Las Vegas”,”NV”,”88888”, “gsmith@GSmithCompany.com”,”(555) 555-5555”,””)
Nogen der kan se hvad den query fejler? Jeg har den fra en bog. Jeg får følgende fejl når jeg prøver at køre den:
"Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '“bigguy”,”2001-Dec-2”,”secret”,”Smith”, “1234 Happy St”,”Las Vegas”,”NV”,”88888' at line 3 "
Det var nogle märkelige plinger. INSERT INTO Member (loginName,createDate,password,lastName, street,city,state,zip,email,phone,fax) VALUES ("bigguy","2001-Dec-2","secret","Smith", "1234 Happy St","Las Vegas","NV","88888", "gsmith@GSmithCompany.com","(555) 555-5555","")
INSERT INTO Member (loginName,createDate,password,lastName, street,city,state,zip,email,phone,fax) VALUES ('bigguy','2001-Dec-2','secret','Smith', '1234 Happy St','Las Vegas','NV','88888', 'gsmith@GSmithCompany.com','(555) 555-5555','') Du skal bruger ' istedet for "
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.