Yea, thanks for the responce, the error is:
An error occurred while evaluating the expression:
#attributes.press_date#
The strange thing is that the example I showed you now works, I inadverantly
fixed it yesterday without realizing it, I still have the error on a
different fuseaction under the same index.cfm so formUrl2attributes is
working fine, somehow or other the form variables are not making it though.
I expect I will find a silly mistake in the next while here and come back to
the list full of humility :)
-Shane
-----Original Message-----
From: Patrick McElhaney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 6:11 AM
To: Fusebox
Subject: RE: attributes.whatever not showing up when passing form
variables to a sql query
Shane,
There are only two things that make sense.
1) For whatever reason, <cf_formURLToAttributes>
isn't included before that query (or perhaps all
of your queries). In this case, you'll get an
error something like "error resoving parameter."
2) Something in your application is causing
either the attributes or the form values to
change. Since in the example you gave, everything
is a text field, odds are this problem would
not throw an error. But if this is the problem,
you should get an ODBC error.
I have a feeling that the fact that the broken
code is in a query is just a coincidence. Look
deeper. The problem most likely has nothing to
do with the database.
Patrick
> -----Original Message-----
> From: Shane Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 3:28 PM
> To: Fusebox
> Subject: attributes.whatever not showing up when passing form variables
> to a sql query
>
>
> Hey people,
> I'm not sure why but, as stated in the subject, I am not
> able to use attributes.formfieldname in my sql queries, I have to use
> form.formfieldname. Is this a known phenom or is there a little something
> extra I should be doing, my app works fine ofcourse but I hate to deviate
> from the fusebox way of using "attributes". I am using attributes
> throughout the application so they are working as per form2url
> specs. I am
> also using the code from the book to reuse the form for edit,new
> and delete,
> perhaps that is affecting things?
>
> This works...
>
> <cfquery name="updatepressrelease" datasource="#request.myDSN#">
> update press
> set
> press_head = '#form.press_head#' ,
> press_head2 = '#form.press_head2#' ,
> press_body = '#form.press_body#'
> where (index like '#pressindex#');
> </cfquery>
>
> This doesn't
>
> <cfquery name="updatepressrelease" datasource="#request.myDSN#">
> update press
> set
> press_head = '#attributes.press_head#' ,
> press_head2 = '#attributes.press_head2#' ,
> press_body = '#attributes.press_body#'
> where (index like '#pressindex#');
> </cfquery>
>
>
>
> Shane Johnson
> Web Production/Programming
> Populuxe Digital Media
> www.populuxe.com
> [EMAIL PROTECTED]
> (604) 714-2496
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
