On Mon, Dec 22, 2003 at 04:24:52PM -0700, Andrew Ayers wrote: > INSERT INTO reg("customer number", "company name", address, city, state, > zip, phone, alt_phone, fax, alt_fax, iaccess, browser, provider, > software, sversion, ynintegrated, ynnewtest, login, password, txtnetid, > alias_1, alias_2, url, approval_password, ynauthalert, loi_date, > contract_eff, contract_term, term_code, main_eff, main_term, live_eff, > renewal_eff, cs_rep, txtactmanager, txtsalesrep, txtprojmanager, > modem_number, dbc_users, intbillableusers, country, mmowarning, > mmositefileflags, verified, buildtimedate, ynhipaaba) VALUES ('855', > 'Test Company', '1234 West Jazz Street', 'Tempe', 'AZ', '85203', '(602) > 123-4567', '(602) 123-4567', '(602) 123-4567', '(602) 123-4567', true, > 'Internet Explorer', DEFAULT, 'HP3.5', '13', false, false, 'eci855', > DEFAULT, DEFAULT, 'Test', 'Tester', 'http:\\www.eldocomp.com\', DEFAULT,
Note here: ^^ > false, DEFAULT, '09/11/2002', DEFAULT, DEFAULT, '09/11/2002', DEFAULT, > DEFAULT, DEFAULT, 'Chris Riesgraf ext. 244', 'Keri Daminelli ext. 246', > 'Kerry Winkle ext. 229', DEFAULT, DEFAULT, DEFAULT, > '0', 'USA', 'afdsf', DEFAULT, DEFAULT, DEFAULT, false); You have an escaped ', which will make the string literal continue till the next '. You should really be escaping your \ and ' when they are embedded in data. Consider something like "Joh\n"; it will insert Joh followed by a newline. Also, an URL with \ is quite weird ... I think they like / best. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) You liked Linux a lot when he was just the gawky kid from down the block mowing your lawn or shoveling the snow. But now that he wants to date your daughter, you're not so sure he measures up. (Larry Greenemeier) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings