|
rikki -> RE: Passing variable from query (5/11/2004 11:15:03)
|
Hi again...
I've gone back to doing as you said with the 3 pages.. just want to get that to work..
page 1 form input
goes to page 2 insert statement
The insert page is giving me a syntax error
I've put the query code at the top .
Help with Insert..
Also.. Does fp automatically send the time stamp? or do I have to include that as a hidden field.?
Thanks
<%
fp_sQry="SELECT COUNT(*) AS MyCount FROM WETASKIWIN1 WHERE (DateStart = #::DateStart::# AND CampSite LIKE '%::CampSite::%')"
fp_sDefault="DateStart=01/09/2004&CampSite="
fp_sNoRecords=""
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="CAMP"
fp_sMenuValue="CAMP"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<%
If FP_FieldVal(fp_rs,"MyCount")>0 Then
Response.Redirect "subheaderfiles/errorpage.asp"
End If
%>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Insert page</title>
</head>
<body>
<!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="INSERT INTO WETASKIWIN1 (CAMP, DateStart, DateEnd, SPECIFICS, ADDRESS, CITY, PROVINCE, POSTALCODE, REGION, CAMPGROUP, [SECTION], YOUTH, ADULTS, EMAIL, OTHER, AREA, FIRSTNAME, LASTNAME, PHONE, [PASSWORD], CHECKINTIME, CHECKOUTTIME, SCOUTING, NONSCOUTING, CampSite) VALUES ( '::CAMP::', #::DateStart::#, #::DateEnd::#, '::SPECIFICS::', '::ADDRESS::', '::CITY::', '::PROVINCE::', '::POSTALCODE::', '::REGION::', '::CAMPGROUP::', '::SECTION::', ::YOUTH::, ::ADULTS::, '::EMAIL::', '::OTHER::', '::AREA::', '::FIRSTNAME::', '::LASTNAME::', '::PHONE::', '::PASSWORD::', '::CHECKINTIME::', '::CHECKOUTTIME::', '::SCOUTING::', '::NONSCOUTING::', '::CampSite::',)"
fp_sDefault="CAMP=Camp WetaskiwinDateStart=01/09/2004DateEnd=01/09/2004SPECIFICS=&ADDRESS=&CITY=&PROVINCE=&POSTALCODE=®ION=&CAMPGROUP=&SECTION=&YOUTH=&ADULTS=&EMAIL=&OTHER=&AREA=&FIRSTNAME=&LASTNAME=&PHONE=&PASSWORD=&CHECKINTIME=&CHECKOUTTIME=&SCOUTING=&NONSCOUTING=&CampSite="
fp_sNoRecords=""
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<form METHOD="POST">
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</form>
</body></html>
|
|
|
|
