Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UPDATING RECORDS

Status
Not open for further replies.
kingjjx

kingjjx

Programmer
Joined
Sep 18, 2001
Messages
181
Location
US
HI, I Need help in my script. Everytime this is called, it displays a blank screen. This takes the Primary Key from the URL and is supposed to display a record so user can edit the record. This is very basic and I am new with COldFusion, Please some one help me.
Thank you

<CFQUERY NAME=&quot;EditDynorun&quot; DATASOURCE=&quot;DynoRunEx&quot;>
SELECT * FROM RunData WHERE PriKey= #URL.PriKey#
</cfquery>

<html>
<head>
<title>EDIT A LISTING</title>
</head>
<body>

<CFOUTPut>
<FORM action=&quot;editdyno2.cfm?PriKey=#URL.PriKey#&quot; method=&quot;post&quot;>
</cfoutput>


<CFOUTPUT QUERY=&quot;EditDynorun&quot;>

PriKey: #EditDynorun.PriKey#
<P>
Make: <INPUT NAME=&quot;Make&quot; VALUE=&quot;#EditDynorun.Make#&quot;>
<P>
Model: <INPUT NAME=&quot;Model&quot; VALUE=&quot;#EditDynorun.Model#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;Model_required&quot; VALUE=&quot;You must enter a Model.&quot;>
<P>
FirstYear: <INPUT NAME=&quot;FirstYear&quot; VALUE=&quot;#EditDynorun.FirstYear#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;FirstYear_required&quot; VALUE=&quot;You must enter a Year.&quot;>
<P>
Last Year: <INPUT NAME=&quot;LastYear&quot; VALUE=&quot;#EditDynorun.LastYear#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;LastYear_required&quot; VALUE=&quot;You must enter something.&quot;>
<P>
GenRunNotes: <INPUT NAME=&quot;GenRunNotes&quot; VALUE=&quot;#EditDynorun.GenRunNotes#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;GenRunNotes_required&quot; VALUE=&quot;You must enter something.&quot;>
<P>
Run1Name: <INPUT NAME=&quot;Run1Name&quot; VALUE=&quot;#EditDynorun.Run1Name#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;Run1Name_required&quot; VALUE=&quot;You must enter something.&quot;>
<P>
Run1Loc: <INPUT NAME=&quot;Run1Loc&quot; VALUE=&quot;#EditDynorun.Run1Loc#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;Run1Loc_required&quot; VALUE=&quot;You must enter a title.&quot;>
<P>
Run1Notes: <INPUT NAME=&quot;Run1Notes&quot; VALUE=&quot;#EditDynorun.Run1Notes#&quot;>
<INPUT type=&quot;hidden&quot; NAME=&quot;Run1Notes_required&quot; VALUE=&quot;You must enter a title.&quot;>
<INPUT TYPE=&quot;Submit&quot;>

</cfoutput>
</body>
</html>
 
Sort by date Sort by votes
possible reason for that is that URL.PriKey is not defined or it is blank and therefore the EditDynorun query will return no records and that will result with blank screen...

check the value of URL.PriKey, make sure it's not blank Sylvano
dsylvano@hotmail.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Luvsql
  • Locked
  • Question Question
Hidden Date Field Issue Not Updating Properly
Replies
3
Views
385
darryncooke
darryncooke
sue0912
  • Locked
  • Question Question
Update Multiple Records
Replies
1
Views
252
sue0912
sue0912
szeiss
  • Locked
  • Question Question
Rendering Recordset in HTML Using Cfdocument
Replies
2
Views
289
cfSearching
cfSearching
scottew
  • Locked
  • Question Question
Updating records
Replies
9
Views
370
scottew
scottew
wjgrayson
  • Locked
  • Question Question
New Template Question : Template updating from a template?
Replies
1
Views
159
vacunita
vacunita

Part and Inventory Search

Sponsor

Back
Top