958 Update Error Blues

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

958 Update Error Blues

John Torres
Alright folks. I'm at my whit's end here. Been working at this for two weeks
on a simple update form, and I am stuck on something that to most people
would seem obvious to fix. I am seeing what FileMaker is calling:

"958 Error While performing FileMaker database -update action. Parameter
missing in query."

***************************************************************************
Step 1 - Here is how my database is defined (Keep in mind that I only want
to update certain fields in the table, not all of them), and I am thinking
that it is here where the problem lies. I've tried turning off indexing and
the auto-enter serial but got nothing.
***************************************************************************

Field Name Type Options/Comments
___________________________________________________________________________
LogID Text Index, Auto-Enter Serial
EventID Text Index
RegID Text Index
FirstName Text
LastName Text
MemberID Text
Gender Text
StudentAdvisor Text
Chapter Text
Full Name Calculation =FirstName & "  " & LastName
Age Text
Grade Text
CampYears Text
____________________________________________________________________________

****************************************************************************
Step 2 The Form (I took out all the fancy HTML for easy reading)
****************************************************************************
<form action="delete-response.lasso" method="post" name="campupdate"
id="campupdate">

[Inline:  -Database='ohffa-registration-persons', -Table='web',
-KeyField='', -op='eq', 'LogID'=$LogID, -MaxRecords='1', -search]
                       
<input type="hidden" name="-KeyValue" value="[KeyField_Value]"/>
                       
Log ID
            [Field:'LogID']

Event ID
            [Field:'EventID']

Registration ID
            [Field:'RegID']

//The three IDs above are just being displayed to the user. These are not
being selected to be updated.

Member ID
<input name="MemberID" type="text" id="MemberID" value="[Field:'MemberID']">

First Name
<input name="FirstName" type="text" id="FirstName"
value="[Field:'FirstName']">

Last Name
<input name="LastName" type="text" id="LastName" value="[Field:'LastName']">

Gender
<input name="Gender" type="text" id="Gender" value="[Field:'Gender']">

Chapter
<input name="Chapter" type="text" id="Chapter" value="[Field:'Chapter']">

Age
<input name="Age" type="text" id="Age" value="[Field:'Age']">

Grade
<input name="Grade" type="text" id="Grade" value="[Field:'Grade']">

Camp Years
<input name="CampYears" type="text" id="CampYears"
value="[Field:'CampYears']">


<input type="submit" name="-Token.Action" value="Update Record">
       
<input type="submit" name="-Token.Action" value="Delete Record">
       
[/Inline]
       
</form>

****************************************************
Step 3 and the most important the processing page!
****************************************************

[Var:'MemberID' = Action_Param:'MemberID']
[Var:'FirstName' = Action_Param:'FirstName']
[Var:'LastName' = Action_Param:'LastName']
[Var:'Gender' = Action_Param:'Gender']
[Var:'Chapter' = Action_Param:'Chapter']
[Var:'Age' = Action_Param:'Age']
[Var:'Grade' = Action_Param:'Grade']
[Var:'CampYears' = Action_Param:'CampYears']

[If: (Token_Value: 'Action') >> 'Delete']
[Variable: 'Action'=-Delete]

[Else]

[Variable: 'Action'=-Update]
[/If]

[Inline:  -Database='ohffa-registration-persons',
-Table='web',
-KeyField='',
'MemberID'=$MemberID,
'FirstName'=$FirstName,
'LastName'=$LastName,
'Gender'=$Gender,
'Chapter'=$Chapter,
'Age'=$Age,
'Grade'=$Grade,
'CampYears'=$CampYears,
$Action]
 
[If: Error_CurrentError != Error_NoError]An error has occurred.

([Error_CurrentError: -ErrorCode] [Error_CurrentError])

[Else: Lasso_CurrentAction == 'delete']The record was successfully deleted.

[/If]

[/Inline]

**************************************************
Step 4 - Where is this 958 Error coming from????
**************************************************


John J. Torres
The Ohio State University
Phone: 614.294.3147 Fax: 614.294.6818
Email: [hidden email]



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: 958 Update Error Blues

Doug Gentry
John -

In your first page (Step 2) you have this:

<input type="hidden" name="-KeyValue" value="[KeyField_Value]"/>

but in Step 3, the response page you have in your inline I don't see  
anyplace where the -keyvalue is passed to the inline. There may be some  
special operations going on here, but here's what I would do/try...

<input type="hidden" name="kfv" value="[KeyField_value]"

then in the response page

[var: 'kfv'=(action_param: 'kfv')]
[inline: ..blah..
-keyfield='',
-keyvalue=($kfv),


This tells Lasso to pass along the unique recordID (for Filemaker) for  
purposes of updating or deleting.

...Doug Gentry




On May 31, 2005, at 8:08 PM, John Torres wrote:

> Alright folks. I'm at my whit's end here. Been working at this for two  
> weeks
> on a simple update form, and I am stuck on something that to most  
> people
> would seem obvious to fix. I am seeing what FileMaker is calling:
>
> "958 Error While performing FileMaker database -update action.  
> Parameter
> missing in query."
>
> ***********************************************************************
> ****
> Step 1 - Here is how my database is defined (Keep in mind that I only  
> want
> to update certain fields in the table, not all of them), and I am  
> thinking
> that it is here where the problem lies. I've tried turning off  
> indexing and
> the auto-enter serial but got nothing.
> ***********************************************************************
> ****
>
> Field Name Type Options/Comments
> _______________________________________________________________________
> ____
> LogID Text Index, Auto-Enter Serial
> EventID Text Index
> RegID Text Index
> FirstName Text
> LastName Text
> MemberID Text
> Gender Text
> StudentAdvisor Text
> Chapter Text
> Full Name Calculation =FirstName & "  " & LastName
> Age Text
> Grade Text
> CampYears Text
> _______________________________________________________________________
> _____
>
> ***********************************************************************
> *****
> Step 2 The Form (I took out all the fancy HTML for easy reading)
> ***********************************************************************
> *****
> <form action="delete-response.lasso" method="post" name="campupdate"
> id="campupdate">
>
> [Inline:  -Database='ohffa-registration-persons', -Table='web',
> -KeyField='', -op='eq', 'LogID'=$LogID, -MaxRecords='1', -search]
>
> <input type="hidden" name="-KeyValue" value="[KeyField_Value]"/>
>
> Log ID
>             [Field:'LogID']
>
> Event ID
>             [Field:'EventID']
>
> Registration ID
>             [Field:'RegID']
>
> //The three IDs above are just being displayed to the user. These are  
> not
> being selected to be updated.
>
> Member ID
> <input name="MemberID" type="text" id="MemberID"  
> value="[Field:'MemberID']">
>
> First Name
> <input name="FirstName" type="text" id="FirstName"
> value="[Field:'FirstName']">
>
> Last Name
> <input name="LastName" type="text" id="LastName"  
> value="[Field:'LastName']">
>
> Gender
> <input name="Gender" type="text" id="Gender" value="[Field:'Gender']">
>
> Chapter
> <input name="Chapter" type="text" id="Chapter"  
> value="[Field:'Chapter']">
>
> Age
> <input name="Age" type="text" id="Age" value="[Field:'Age']">
>
> Grade
> <input name="Grade" type="text" id="Grade" value="[Field:'Grade']">
>
> Camp Years
> <input name="CampYears" type="text" id="CampYears"
> value="[Field:'CampYears']">
>
>
> <input type="submit" name="-Token.Action" value="Update Record">
>
> <input type="submit" name="-Token.Action" value="Delete Record">
>
> [/Inline]
>
> </form>
>
> ****************************************************
> Step 3 and the most important the processing page!
> ****************************************************
>
> [Var:'MemberID' = Action_Param:'MemberID']
> [Var:'FirstName' = Action_Param:'FirstName']
> [Var:'LastName' = Action_Param:'LastName']
> [Var:'Gender' = Action_Param:'Gender']
> [Var:'Chapter' = Action_Param:'Chapter']
> [Var:'Age' = Action_Param:'Age']
> [Var:'Grade' = Action_Param:'Grade']
> [Var:'CampYears' = Action_Param:'CampYears']
>
> [If: (Token_Value: 'Action') >> 'Delete']
> [Variable: 'Action'=-Delete]
>
> [Else]
>
> [Variable: 'Action'=-Update]
> [/If]
>
> [Inline:  -Database='ohffa-registration-persons',
> -Table='web',
> -KeyField='',
> 'MemberID'=$MemberID,
> 'FirstName'=$FirstName,
> 'LastName'=$LastName,
> 'Gender'=$Gender,
> 'Chapter'=$Chapter,
> 'Age'=$Age,
> 'Grade'=$Grade,
> 'CampYears'=$CampYears,
> $Action]
>
> [If: Error_CurrentError != Error_NoError]An error has occurred.
>
> ([Error_CurrentError: -ErrorCode] [Error_CurrentError])
>
> [Else: Lasso_CurrentAction == 'delete']The record was successfully  
> deleted.
>
> [/If]
>
> [/Inline]
>
> **************************************************
> Step 4 - Where is this 958 Error coming from????
> **************************************************
>
>
> John J. Torres
> The Ohio State University
> Phone: 614.294.3147 Fax: 614.294.6818
> Email: [hidden email]
>
>
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>

---
Doug Gentry
Dynapolis & Southern Oregon University
p:  541-261-8501 / Toll Free: 888-490-0644
[hidden email]


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: 958 Update Error Blues

John Torres
In reply to this post by John Torres
Doug,

Let me tell you that you are the MAN! It is a bit after midnight, and I am a
college senior going through my last finals week. Although I have pushed
aside my academic work to get my work "work" done, I feel more completion
now than what I ever have after finishing any test.

Cheers!

John

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf
Of Doug Gentry
Sent: Tuesday, May 31, 2005 11:23 PM
To: [hidden email]
Subject: Re: 958 Update Error Blues

John -

In your first page (Step 2) you have this:

<input type="hidden" name="-KeyValue" value="[KeyField_Value]"/>

but in Step 3, the response page you have in your inline I don't see  
anyplace where the -keyvalue is passed to the inline. There may be some  
special operations going on here, but here's what I would do/try...

<input type="hidden" name="kfv" value="[KeyField_value]"

then in the response page

[var: 'kfv'=(action_param: 'kfv')]
[inline: ..blah..
-keyfield='',
-keyvalue=($kfv),


This tells Lasso to pass along the unique recordID (for Filemaker) for  
purposes of updating or deleting.

...Doug Gentry




On May 31, 2005, at 8:08 PM, John Torres wrote:

> Alright folks. I'm at my whit's end here. Been working at this for two  
> weeks
> on a simple update form, and I am stuck on something that to most  
> people
> would seem obvious to fix. I am seeing what FileMaker is calling:
>
> "958 Error While performing FileMaker database -update action.  
> Parameter
> missing in query."
>
> ***********************************************************************
> ****
> Step 1 - Here is how my database is defined (Keep in mind that I only  
> want
> to update certain fields in the table, not all of them), and I am  
> thinking
> that it is here where the problem lies. I've tried turning off  
> indexing and
> the auto-enter serial but got nothing.
> ***********************************************************************
> ****
>
> Field Name Type Options/Comments
> _______________________________________________________________________
> ____
> LogID Text Index, Auto-Enter Serial
> EventID Text Index
> RegID Text Index
> FirstName Text
> LastName Text
> MemberID Text
> Gender Text
> StudentAdvisor Text
> Chapter Text
> Full Name Calculation =FirstName & "  " & LastName
> Age Text
> Grade Text
> CampYears Text
> _______________________________________________________________________
> _____
>
> ***********************************************************************
> *****
> Step 2 The Form (I took out all the fancy HTML for easy reading)
> ***********************************************************************
> *****
> <form action="delete-response.lasso" method="post" name="campupdate"
> id="campupdate">
>
> [Inline:  -Database='ohffa-registration-persons', -Table='web',
> -KeyField='', -op='eq', 'LogID'=$LogID, -MaxRecords='1', -search]
>
> <input type="hidden" name="-KeyValue" value="[KeyField_Value]"/>
>
> Log ID
>             [Field:'LogID']
>
> Event ID
>             [Field:'EventID']
>
> Registration ID
>             [Field:'RegID']
>
> //The three IDs above are just being displayed to the user. These are  
> not
> being selected to be updated.
>
> Member ID
> <input name="MemberID" type="text" id="MemberID"  
> value="[Field:'MemberID']">
>
> First Name
> <input name="FirstName" type="text" id="FirstName"
> value="[Field:'FirstName']">
>
> Last Name
> <input name="LastName" type="text" id="LastName"  
> value="[Field:'LastName']">
>
> Gender
> <input name="Gender" type="text" id="Gender" value="[Field:'Gender']">
>
> Chapter
> <input name="Chapter" type="text" id="Chapter"  
> value="[Field:'Chapter']">
>
> Age
> <input name="Age" type="text" id="Age" value="[Field:'Age']">
>
> Grade
> <input name="Grade" type="text" id="Grade" value="[Field:'Grade']">
>
> Camp Years
> <input name="CampYears" type="text" id="CampYears"
> value="[Field:'CampYears']">
>
>
> <input type="submit" name="-Token.Action" value="Update Record">
>
> <input type="submit" name="-Token.Action" value="Delete Record">
>
> [/Inline]
>
> </form>
>
> ****************************************************
> Step 3 and the most important the processing page!
> ****************************************************
>
> [Var:'MemberID' = Action_Param:'MemberID']
> [Var:'FirstName' = Action_Param:'FirstName']
> [Var:'LastName' = Action_Param:'LastName']
> [Var:'Gender' = Action_Param:'Gender']
> [Var:'Chapter' = Action_Param:'Chapter']
> [Var:'Age' = Action_Param:'Age']
> [Var:'Grade' = Action_Param:'Grade']
> [Var:'CampYears' = Action_Param:'CampYears']
>
> [If: (Token_Value: 'Action') >> 'Delete']
> [Variable: 'Action'=-Delete]
>
> [Else]
>
> [Variable: 'Action'=-Update]
> [/If]
>
> [Inline:  -Database='ohffa-registration-persons',
> -Table='web',
> -KeyField='',
> 'MemberID'=$MemberID,
> 'FirstName'=$FirstName,
> 'LastName'=$LastName,
> 'Gender'=$Gender,
> 'Chapter'=$Chapter,
> 'Age'=$Age,
> 'Grade'=$Grade,
> 'CampYears'=$CampYears,
> $Action]
>
> [If: Error_CurrentError != Error_NoError]An error has occurred.
>
> ([Error_CurrentError: -ErrorCode] [Error_CurrentError])
>
> [Else: Lasso_CurrentAction == 'delete']The record was successfully  
> deleted.
>
> [/If]
>
> [/Inline]
>
> **************************************************
> Step 4 - Where is this 958 Error coming from????
> **************************************************
>
>
> John J. Torres
> The Ohio State University
> Phone: 614.294.3147 Fax: 614.294.6818
> Email: [hidden email]
>
>
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>

---
Doug Gentry
Dynapolis & Southern Oregon University
p:  541-261-8501 / Toll Free: 888-490-0644
[hidden email]


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage