Database results help

	Home Register Search Help Login

Sponsors

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

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

Database results help

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 >> Database results help

Page: [1]


Ace Posts: 6 Joined: 8/12/2003 Status: offline	Database results help - 8/12/2003 11:21:49 Hi people, let me start off by saying this forum is superb! it's helped me out a lot! anyway, I have a few databases running fine on my webserver, I have added a link into the database results to hyperlink to another page that displays the single record, but I need that single record to be a form (just like an order form) so the user simply submits the order and I recieve it via email. (hope this makes sense) any help would be greatly appriciated! Cheers folks Daz


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Database results help - 8/13/2003 3:51:17 Welcome! :) Check out http://www.frontpagehowto.com/dbandemail.htm TO actually enter into a form, youll use step 4 of the DRW to format the DRW output that you need. _____________________________ 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 Ace)


Ace Posts: 6 Joined: 8/12/2003 Status: offline	RE: Database results help - 8/13/2003 7:26:30 Hi mate, I have used step 4 of the DRW to output to a form, but when I ask it to send to either a filename or an email address it doesn't write to any kind of file, I have tried txt, asp and html files.. weird... any suggestions? (in reply to Ace)


Ace Posts: 6 Joined: 8/12/2003 Status: offline	RE: Database results help - 8/13/2003 7:28:47 this is the reply I get after submitting the form: Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '(ID = )'. Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for ODBC Drivers One or more form fields were empty. You should provide default values for all form fields that are used in the query. (in reply to Ace)


Ace Posts: 6 Joined: 8/12/2003 Status: offline	RE: Database results help - 8/18/2003 11:31:31 he quote: r lp???? (in reply to Ace)


Mike54 Posts: 4791 Joined: 3/26/2001 From: Way Up Over Status: offline	RE: Database results help - 8/18/2003 13:16:36 Hi Ace, The first thing I do when I get that error (and it's no guarenteed cure all) is to open the (database) table in design view and make sure all my fields are set to allow zero length. Thumbnail Image Attachment (1) _____________________________ Who was the first guy that looked at a cow and said, "I think that I'll drink whatever comes out of those things when I squeeze them"? New photogalleries, stop by sometime. (in reply to Ace)


Ace Posts: 6 Joined: 8/12/2003 Status: offline	RE: Database results help - 8/18/2003 13:21:16 Hi thanx, it seems to be working now... (well getting no errors anyway) but I have asked the form to "send to test.asp" and email to my email address but it's not writing anything to the asp file or sending any message! c'mon nerds, help me out! :-) (in reply to Ace)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Database results help - 8/18/2003 13:34:28 Do you have a URL or some code we can look at? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to Ace)


Ace Posts: 6 Joined: 8/12/2003 Status: offline	RE: Database results help - 8/18/2003 13:38:52 sure: http://217.34.50.124/testing/tektronixxerox.asp do a search for the printer model 300 and select consumables then click order on the right side. It will goto the result (which is also a form) and when you click submit it looks fine, but nothing is written to any pages etc.. getting a bit annoying now.. (in reply to Ace)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Database results help - 8/18/2003 14:35:17 quote: It will goto the result (which is also a form) and when you click submit it looks fine, but nothing is written to any pages etc.. That results page doesn't seem to have any "Action" on that page to do anything with. It just points back to itself: <form method="POST" action="Salesform.asp" name="refsdfd" webbot-action="--WEBBOT-SELF--"> That is the <form> tag on the results page. What is it supposed to do when I click the Submit on Salesform.asp ? Is that page supposed to be emailing? If you want Salesform.asp to submit to another form handler, you'll need the <form> tag to point to that page. IF Salesform.asp will be doing the emailing, the code will have to be on that page. Does that make sense or am I confusing you??? Can you clarify a little more for me? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to Ace)