INSERT works fine with a carriage return too: <cfquery name="InsertQ" datasource="SimpleDB" dbtype="amazon"> INSERT INTO Track(ItemName, Att1, Att2) VALUES (id1, Val1, Val2) </cfquery>
does not error. Baz On Tue, Apr 28, 2009 at 3:52 PM, Baz <[email protected]> wrote: > This DELETE query runs fine: > > <cfquery name="DeleteQ" datasource="SimpleDB" dbtype="amazon"> > DELETE FROM Track WHERE ItemName=<cfqueryparam > value="E927D784-7B2D-4B54-90C677B90D188CAC" /> > </cfquery> > > But the same query with a carriage return does not: > > <cfquery name="DeleteQ" datasource="SimpleDB" dbtype="amazon"> > DELETE > FROM Track WHERE ItemName=<cfqueryparam > value="E927D784-7B2D-4B54-90C677B90D188CAC" /> > </cfquery> > > SELECT queries work fine with or without carriage returns. > > Should I document this as a bug? > > Baz > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
