| 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> |
|---|---|---|
| ||
| Previous by Date: | Re: Simple Update Kicking my behind, kirkdickinson |
|---|---|
| Next by Date: | Re: Simple Update Kicking my behind, Dan Bracuk |
| Previous by Thread: | Re: Simple Update Kicking my behind, kirkdickinson |
| Next by Thread: | Re: Simple Update Kicking my behind, Dan Bracuk |
| Indexes: | [Date] [Thread] [Top] [All Lists] |