Ask a Question related to Coldfusion Database Access, Design and Development.
-
jhutchdublin #1
cfinsert help
I would like to have people insert information into a database. It's a single
table in a database, so I thought I would try <cfinsert>
I'm getting a message that says I need to have a number placed in the cst_id,
it can't be left blank. My question is -- how do I do this using cfinsert, or
can I do this using cfinsert?
I have included the code I have so far
<cfinsert datasource="irish"
tablename="tbl_customers"
formfields = "CST_FIRSTNAME,
CST_LASTNAME,
CST_ADDRESS1,
CST_ADDRESS2,
CST_CITY,
CST_ZIP,
CST_PHONE,
CST_EMAIL">
jhutchdublin Guest
-
about cfinsert tag error!
please look this code: <cfif IsDefined("Form.posted")> <cfinsert datasource="test" tablename="users"... -
insert using cfinsert
I have been trying to upgrade my server from CF 5 to CF 7. I have a table as keywords with the attributes as follows: ID int (primary key) keyword... -
cfinsert from javascript
I have write javascript to create form field when button is click. function addEvent(myTable){ var lastRow = myTable.rows.length; var... -
CFInsert
Hi. I was hoping I could get help on an issue. I am using CFInsert to add data from a form into two tables that are related. Table 1: Members... -
CFinsert misbehaves
Any ideas why a CFinsert tag would work on my partner's desktop and not on my laptop? Both are using CF 6.0 and MS Access database. All the... -
dmuniz #2 Re: cfinsert help
Is cst_ID the primary key of tbl_customers?
If so, you should make sure that the field is set as Primary key and that the identity is turned on. This way the value is set by the DB engine.
dmuniz Guest
-
jhutchdublin #3 Re: cfinsert help
This has been set by the primary key for the database
jhutchdublin Guest
-
Dan Bracuk #4 Re: cfinsert help
Originally posted by: jhutchdublin
This has been set by the primary key for the database
If your db autoincrements that field for you, change your cfinsert to a
cfquery and things will work better.
Dan Bracuk Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
