No command has been set for the command object ???

<i><b>Originally posted by : steve (stevehammond@mail.com)</b></i><br />I keep getting the following error "No command has been set for the command object" does anyone have any suggestions?<br /><br />Thanks,<br />Steve

<i><b>Originally posted by : Barry</b></i><br /><br />I have seen this a few times....<br /><br />It is generally generated when I pass an empty variable as an SQL statement to the connection or recordset object.<br /><br />If you are building an sql statement make sure that you are sending something int the variable.<br /><br />With other objects I assume that the same error would occur if you were passing it a null.<br /><br />------------<br />steve at 4/8/2000 9:47:17 AM<br /><br />I keep getting the following error "No command has been set for the command object" does anyone have any suggestions?<br /><br />Thanks,<br />Steve