passing along an id number as part of a URL. The
application is supposed to allow a user to add a new
record to a personnel table and then either stop there
or click a link to go to another page to add a record
into a vehicle table for the person who was added to
the personnel table. The database is Access 2000. The
"add-a-user" part works, but it sends empty space
instead of the ID autonumber created for the new
personnel record to the "add-a-vehicle" page so that
it can be put into a new vehicle record, see below:
http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKey=
where I am expecting
http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKey=21486
Here is the pertinent code:
<cfset NewID = "">
<cfset PersonnelKey = "">
<cfquery name="GetNewID" datasource="CMISPersonnel">
Select Max(PersonnelKey) as NewID from Personnel
</cfquery>
<cfset PersonnelKey eq #GetNewID.NewID#>
<cfoutput>
<p>#Form.FirstName# #Form.LastName# has been added to
the personnel database.</p>
Click the "Add Permit" link to add permit information
for this person.<br>
Or make another selection from the menu.
<p>
<a
href="">Permit for #Form.FirstName# #Form.LastName#</a>
</cfoutput>
That's problem #1. Problem #2 is a little strange; the
error message claims that a commented-out line is
causing the problem. Originally, I was getting an
error message about a syntax error in my INSERT INTO
SQL statement. When I commented out the named field to
see if I could isolate the error, the new error
message referenced the commented line, as below.
[MERANT][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver]
Syntax error in INSERT INTO statement.
The Error Occurred in
D:\CFusionMX\wwwroot\InfoCenter\Parking\addpermitv_action_test.cfm:
line 25
23 : <!-- Temporarily commented out
'#FORM.CarValidateContentFlag#') -->
24 :
25 : </cfquery>
26 : <cfoutput>
27 : The new permit information has been submitted.
Please make another selection
SQL INSERT INTO Vehicles(PersonnelKey, Year, Make,
Model, Color, TagNumber, TagState, DecalNumber,
DecalColor, DecalExpiration, InsuranceCompany,
PolicyNumber, InsuranceExpirationDate, PermitNumber,
IssuedBy, IssueDate, ExpirationDate)
VALUES('URL.PersonnelKey', '1982', 'Chrome Wheeled',
'Fuel Injected', 'Black', '174CZP', 'AL', '47',
'white', '70303', 'State Farm', '42787', '123004',
'477', 'ted', '111202', '111204')
The first value to be inserted is supposed to be the
id number passed along from the previous page -- which
at this point is NOT getting passed along -- which
makes me wonder if these two issues are connected.
Here is the full code for the page giving this error
message:
<!-- Initialize variable -->
<CFPARAM NAME="FORM.CarValidateContentFlag"
DEFAULT="0">
<html>
<head>
<title>Add Permit Action Form</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<p>
<font face="Arial, Helvetica, sans-serif"
size="+2">Add Permit Action Form</font>
</p>
<cfquery name="AddVehicle"
datasource="CMISPersonnel">
INSERT INTO Vehicles(PersonnelKey, Year, Make, Model,
Color, TagNumber, TagState,
DODDecalNumber, DODDecalColor, DODDecalExpiration,
InsuranceCompany, PolicyNumber,
InsuranceExpirationDate, PermitNumber, IssuedBy,
IssueDate, ExpirationDate)
<!-- temporarily commented out
ValidateContentFlag) -->
VALUES('#PersonnelKey#', '#Trim(FORM.Year)#',
'#Trim(FORM.Make)#', '#Trim(FORM.Model)#',
'#Trim(FORM.Color)#', '#Trim(FORM.TagNumber)#',
'#Trim(FORM.TagState)#',
'#Trim(FORM.DODDecalNumber)#',
'#Trim(FORM.DODDecalColor)#',
'#Trim(FORM.DODDecalExpiration)#',
'#Trim(FORM.InsuranceCompany)#',
'#Trim(FORM.PolicyNumber)#',
'#Trim(FORM.InsuranceExpirationDate)#',
'#Trim(FORM.PermitNumber)#',
'#Trim(FORM.IssuedBy)#', '#Trim(FORM.IssuedDate)#',
'#Trim(FORM.ExpirationDate)#')
<!-- Temporarily commented out
'#FORM.CarValidateContentFlag#') -->
</cfquery>
<cfoutput>
The new permit information has been submitted. Please
make another selection
from the menu to continue.
</cfoutput>
</body>
</html>
Can anyone help me figure this out? Thanks.
Laura
====================================================
Laura Schlee
DML Associates
cell 703-622-0363
ofc 202-685-1360
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
