Ok. now I know that it is time to go home. The reason that it wasn't
working is because the qry_ file wasn't included in my fuse block.
Yes I feel stupid now.
Thanks Fred for validating that my index file did look correct :-)
- Jeff Giesbrecht
-----Original Message-----
From: "Giesbrecht, Jeffrey" <[EMAIL PROTECTED]>
Sent: Thursday, September 21, 2000 3:54 PM
To: Giesbrecht, Jeffrey; [EMAIL PROTECTED]
Subject: RE: fuses not working
It basically bombs on the first variable. And it doesn't matter whether
I call it with the query name or with the attributes name. But in
thinking it over the attributes scope shouldn't work anyway.
Here is my query in a file called qry_patent_info.cfm
<CFQUERY NAME="patent_info" DATASOURCE="#attributes.DSN#">
SELECT *
FROM InventionWorksheet
WHERE RecordID = <cfoutput>#attributes.Patent_id#</cfoutput>
ORDER BY PNum
</CFQUERY>
Here is some code from the dsp_patent file:
<cfoutput>
<form action="index.cfm?fuseaction=submit_patent" method="post"
name="Patent_Info" id="Patent_Info">
<br>
<br>
<table cellspacing="0" cellpadding="5" border="1" width="612">
<tr>
<td valign="middle" align="right" height="21" width="190">Patent
Number:
</td>
<td height="21" valign="middle" width="402">
<input type="text" name="PNum" value=<cfif fuseaction eq
"modify">#patent_info.PNum#</cfif>>
</td>
</tr>
<tr>
<td align="right" valign="top" width="190" height="41">Title:</td>
<td valign="middle" width="402" height="41">
<textarea name="Title" cols="35" rows="3"><cfif fuseaction eq
"modify">#patent_info.Title#</cfif></textarea>
</td>
</tr>
<tr>
<td align="right" valign="middle" width="190" height="37">Matter
Number:
</td>
<td valign="middle" width="402" height="37">
<input type="text" name="MatterNum" value=<cfif fuseaction eq
"modify">#patent_info.MatterNum#</cfif>>
</td>
</tr>
-----Original Message-----
From: "Fred T. Sanders" <[EMAIL PROTECTED]>
Sent: Thursday, September 21, 2000 3:36 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: fuses not working
The fuseactions look fine, think you could show us some of the code from
those files?
Fred
----- Original Message -----
From: "Giesbrecht, Jeffrey" <[EMAIL PROTECTED]>
To: "Fusebox" <[EMAIL PROTECTED]>
Sent: Thursday, September 21, 2000 4:16 PM
Subject: fuses not working
> I am still learning the whole fusebox methodology and have an
application
> that I am writing fuse box. I seem to be having a little trouble with
the
> query files being applied.
>
> I have the formurl2attributes tag at the top of my index file and then
I
> have my files being included like so:
> <cfparam name=attributes.fuseaction default="showall">
>
> <cfswitch expression="#attributes.fuseaction#">
> <cfcase value="showall">
> <cfinclude template="qry_getstates.cfm">
> <cfinclude template="qry_patent_list.cfm">
> <cfinclude template="dsp_all_patents.cfm">
> </cfcase>
> <cfcase value="modify">
> <cfinclude template="qry_inventor_names.cfm">
> <cfinclude template="qry_p_state.cfm">
> <cfinclude template="dsp_patent.cfm">
> </cfcase>
> </cfswitch>
>
> The only problem is that in the dsp_patent file I am told that it
can't
find
> the variables. Either with the query name.variable name or with the
> attributes.variable name.
>
> I can't figure out what I am doing wrong.
>
> Thanks for all help.
>
> Jeff Giesbrecht
>
>
--------------------------------------------------------------------------
----
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the
body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the
body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
