Writing Form Results to Excell Sheet and returning to page

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
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.

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

Writing Form Results to Excell Sheet and returning to page

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, PHP, and Database >> Writing Form Results to Excell Sheet and returning to page

Page: [1]


earlm Posts: 6 Joined: 3/20/2003 Status: offline	Writing Form Results to Excell Sheet and returning to page - 4/14/2003 7:20:30 I have tried to use an excel sheet as the database for collecting form results and then displaying them in an included page. After some minor hassles I managed to get both pages happy in FP, (ie, they saved without further error messages). When I go to the results page http://www.makeartnotwar.net/events.asp I can see this code displayed in Opera. <% fp_sQry=" SELECT * FROM " " Events" " ORDER BY Event ASC,City ASC,Street ASC,Location ASC,Suburb ASC,Day ASC,Month ASC,Date ASC,Year ASC,Organiser ASC,Contact ASC,Comments ASC" fp_sDefault=" " fp_sNoRecords=" Sorry, No Events Listed Yet" fp_sDataConn=" Events" fp_iMaxRecords=20 fp_iCommandType=1 fp_iPageSize=10 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice=" " fp_sMenuValue=" " fp_iDisplayCols=12 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %> Event: <%=FP_FieldVal(fp_rs," Event" )%> City: <%=FP_FieldVal(fp_rs," City" )%> Suburb: <%=FP_FieldVal(fp_rs," Suburb" )%> Street: <%=FP_FieldVal(fp_rs," Street" )%> Location: <%=FP_FieldVal(fp_rs," Location" )%> Day: <%=FP_FieldVal(fp_rs," Day" )%> Month: <%=FP_FieldVal(fp_rs," Month" )%> Date: <%=FP_FieldVal(fp_rs," Date" )%> Year: <%=FP_FieldVal(fp_rs," Year" )%> Organiser: <%=FP_FieldVal(fp_rs," Organiser" )%>organiser: <%=FP_FieldVal(fp_rs," Contact" )%> Comments: <%=FP_FieldVal(fp_rs," Comments" )%> although IE5.5 just shows the bulleted field names, despite telling the page to return a " No results" message if there is nothing in the DB yet The form is at http://www.makeartnotwar.net/forms/add_event.asp but when I click the link I am asked whether I want to download the file or open it in FP even if I type the URL into the location bar. Why would it load one asp as a web page but try to open the other in FP? Bizarre. Help please. < Message edited by earlm -- 4/14/2003 7:50 AM >