macromedia.coldfusion.database_access
[Top] [All Lists]

Re: Simple Update Kicking my behind

Subject: Re: Simple Update Kicking my behind
From: Azadi <azadi@xxxxxxxxxxxxx>
Date: Thu, 31 Jan 2008 09:47:17 +0700
Newsgroups: macromedia.coldfusion.database_access


lots of things, possibly, are messed up here.
1) Date Added - make sure you are passing a date if the field is of type DATE: right now you are passing it a string 2) DateUpdated - make sure you are passing it a date in a format accepted by the field 2.1) the singl quotes in the timestamp in DateUPDATED value may be causing trouble? 3) Active - what type of field is this one? Sure it accepts a string? Does it maybe expect an integer 1 or 0? or a 'yes'/'no', or true/false?
4) same as 3) above for ShowOnSite field.
5) some DBs have PASSWORD as a reserved word - avaoid using it as table/column name.


---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

<Prev in Thread] Current Thread [Next in Thread>