Gitte Wange wrote:
On 03 Apr 2001 10:30:01 -0600, Casey Duncan wrote:
Gitte Wange wrote:
Now I get the following error after hitting the submit button: Error Type: error Error Value: You have an error in your SQL syntax near '['2', '2', '2', '2', '2', '2', '2', '2', '2']' at line 1
Yes I am stupid but I don't understand what the problem is. The argument for my sql method is: ids:list
What is the SQL code you used?
-- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------>
The one you wrote: DELETE FROM clips WHERE <dtml-sqltest name="ids" column="id" type="int" multiple>
The reason why I asked is that the list is of strings not ints. Assuming the id is an int in the database, you need to change the checkbox names to "ids:int:list" which I believe will result in a list of ints being passed to the SQL method. Also, does it show you the SQL generated in its entirety when you get the error? If so, what is it? -- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------>