RE: INSERT SELECT Problem

Hi, Try setting the default value of the column to 'Yes' that should work or INSERT INTO Allocations(Project_ID, User_ID, field) SELECT P.Project_ID, U.User_ID, 'Yes' FROM Users U, Projects P, Clients C WHERE P.Client_ID = C.Client_ID AND U.Client_ID = C.Client_ID AND Project_ID =.$project_id)

Query problem in Perl

Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does