insert into Messages
(PostTitle,PostAuthor,PostDate,MessageContent)
Values
('#edittitle#','#cookie.cfmsource_uname#','#writedate#','#editmessage#')
The above query works on one of my apps so... let's see the basic
differences
Your table has a . in the name?
Your first field in the Values list is not 'quoted'.
Maybe this comparison will help?
Tony Hicks
INSERT INTO dbo.CDsTrack {TitleID,TrackName}
VALUES {157,'This is a track'}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
