Can't submit or edit records in database via Submission Form

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Can't submit or edit records in database via Submission Form

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Can't submit or edit records in database via Submission Form

Page: [1]


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	Can't submit or edit records in database via Submission... - 12/5/2006 13:32:50 I'm very new into this, so I apologize if this is an obvious issue... I set up and access database via the Database interface wizard. However, the submission form & database editor pages that are created by the wizard are not working... I get the following message: "The operation failed. If this continues, please contact your server administrator." The fields in the access database the wizard created are all text fields and named as follows: Phone, Name, Address, City, Availability I would appreciate any help. thx.


jeepless Posts: 227 Joined: 12/20/2003 From: Smack in the middle of USA Status: offline	RE: Can't submit or edit records in database via Submis... - 12/5/2006 14:31:58 I belive "Name" is a reserved word for Access databases. Change that field name to something slightly different, rebuild your database editor pages using the Database Interface Wizard, then try it again. For a list of reserved words, see the FAQ post just above this one. Hope that helps. _____________________________ The problem with designing a system that's foolproof is that designers underestimate complete fools. (in reply to abodamer)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/5/2006 15:12:08 It seems you can't use "Name" which is weird, because when you ask it to create a database, that's one of the field names it defaults with.... Anyway, I just created a simple database with a single field called test with no security to edit and I'm still getting the same error message. Again, I can view files fine....so it sees the database. Ideas? (in reply to jeepless)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Can't submit or edit records in database via Submis... - 12/5/2006 15:20:16 Check this post to see the true error? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to abodamer)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/5/2006 15:39:25 in my _fpclass folder there are only 4 files: dbquery.ascx dbregion.ascx fpdbnet.cs fputil.cs (in reply to Spooky)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 12:11:28 bump. No insights? (in reply to abodamer)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 13:40:05 Can you display data from this DB ? (I cant be much more specific as I havent used the aspx version) _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to abodamer)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 14:32:44 yes, I can display data. However I can not submit or edit data. (in reply to Spooky)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 14:47:41 Are you able to use a custom SQL string to insert data from the wizard? eg : "INSERT INTO DB (test) VALUES ('testdata')" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to abodamer)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 14:55:40 Not sure how to do that? here's the form: http://www.bodamer.com/leaco/dsl/dsl_interface/Results/editor/submission_form.aspx feel free to import the www.bodamer.com/leaco/dsl web quote: INSERT INTO DB (test) VALUES ('testdata')" (in reply to Spooky)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 15:08:37 In the file dbquery.ascx, change this line : private bool _showDebug = false; to : private bool _showDebug = true; Then try again? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to abodamer)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 16:14:25 OK I did that & updated via frontpage... still get: The operation failed. If this continues, please contact your server administrator. (in reply to Spooky)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Can't submit or edit records in database via Submis... - 12/18/2006 17:39:09 With a new page, go insert > database > results > and choose asp.net Then at the next step, can you add a custom SQL string using "INSERT" to try and add a record into the database that way? the method is similar to the DRW link in my sig. _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to abodamer)


abodamer Posts: 8 Joined: 12/5/2006 Status: offline	RE: Can't submit or edit records in database via Submis... - 12/19/2006 17:32:25 I appreciate your patience with me. But you'll have to "talk slower." I'm VERY green with respect to this whole process. here's my results page: http://www.bodamer.com/leaco/dsl/dsl_interface/Results/results_page.aspx you can try to submit data & see what I'm experiencing: User Name: Admin Password: Le@c0 (in reply to Spooky)