>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>
It should be:
<cfset PersonnelKey = GetNewID.NewID>
What you're doing right now is a boolean test to see if the current value of
PersonnelKey equals GetNewID.NewID. And since you're not setting the result
of the boolean test to a variable, the default blank string you set for
PersonnelKey is what gets passed.
>
>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.
Try using SQL comments instead of ColdFusion's ( -- vs. <!--- --->).
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
