Does your database require you to specify the column names? i.e. INSERT INTO selecttable(sql) values(?)
? (You didn't say which database you were using) SRH -- Steve Haslam, Developer for Activis; Integralis Ltd, Theale http://www.activis.com/ W:+44-118-923-5272 -----Original Message----- From: anthony [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 14:14 To: [EMAIL PROTECTED] Subject: Insert Statment Hi, is it possible if I have $a="SELECT FROM table WHERE language= english"; and I want to put the statment as text into the database like so INSERT INTO selecttable values(?); $sth->execute($a); I'm getting an error so maybe it is not possible. Any help is appreciated. Anthony Please note that: 1. This e-mail may constitute privileged information. If you are not the intended recipient, you have received this confidential email and any attachments transmitted with it in error and you must not disclose, copy, circulate or in any other way use or rely on this information. 2. E-mails to and from the company are monitored for operational reasons and in accordance with lawful business practices. 3. The contents of this email are those of the individual and do not necessarily represent the views of the company. 4. The company does not conclude contracts by email and all negotiations are subject to contract. 5. The company accepts no responsibility once an e-mail and any attachments is sent. http://www.activis.com This annotation was added by the e-scan service. http://www.activis.com ---------------------------------------------------------------------------------- This message has been checked for all known viruses by e:)scan. For further information please contact [EMAIL PROTECTED]
