Ask a Question related to Coldfusion Database Access, Design and Development.
-
Yuanhui9 #1
about cfinsert tag error!
please look this code:
<cfif IsDefined("Form.posted")>
<cfinsert datasource="test" tablename="users"
formfields="Username,Password,RealName,Email">
</cfif>
<form name="addUser" method="post" action="insert.cfm" preservedata="yes">
Username: <input type="text" name="Username"><br />
Password: <input type="password" name="Password"><br />
Real Name: <input type="text" name="RealName"><br />
Email: <input type="text" name="Email"><br />
<input type="hidden" name="posted" value="<cfoutput>#Now()#</cfoutput>">
<input type="submit" name="Submit" value="Add">
</form>
Error Executing Database Query.
INSERT INTO ????????
The error occurred in D:\cfwwwroot\test\insert.cfm: line 10
8 : <body>
9 : <cfif IsDefined("Form.posted")>
10 : <cfinsert datasource="test" tablename="users"
formfields="Username,Password,RealName,Email">
11 : </cfif>
12 : <form name="addUser" method="post" action="insert.cfm" preservedata="yes">
Yuanhui9 Guest
-
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... -
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> SQL syntax error?
I'm stuck on what should be a simple looping upload, and I'm hoping someone point me in the right direction. Here is what I'm doing: 1) Reading... -
BKBK #2 Re: about cfinsert tag error!
Do datasource test and table users actually exist? Does users contain
columns named Username,Password,RealName and Email?
A point aside. I know it is written as you have in the documentation and
elsewhere, but I believe this is better:
<cfoutput><input type="hidden" name="posted" value="#Now()#"></cfoutput>
BKBK Guest
-
Yuanhui9 #3 Re: about cfinsert tag error!
i'm change database driver from Microsoft Access with Unicode to Microsoft Access, OK!
Why?
Yuanhui9 Guest
-
Dan Bracuk #4 Re: about cfinsert tag error!
Good question. BKBK didn't make the suggestion, so why are you changing
drivers?
Going back to your original post, what was the sql generated by Cold Fusion?
It should have been included in the error message, or did you really get those
little squares.
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
