[thelist] CF Question

Thanks for the suggestions - hopefully this additional code will help.

I want to keep my primary key reader_id with its corresponding information,
but not have it shown to the users. So while in a <cfoutput query> block on
the form page, I use

<input type="hidden" name="reader_id" value="#reader_id#">

Then on the action page I need to use the value of reader_id within my sql
update statement.
So I use it within a CFQUERY tag like this:
<CFQUERY .....>
  update reader_table
  set read_status=1
  where reader_id='#form.reader_id#'
</CFQUERY>

This returns an oracle error code of 1722 - invalid number.


In an attempt to debug this, I included some javascript message boxes to
show the value of reader_id at different points in the code like this:

<cfif IsDefined("form.reader_id")>
  <cfset tmp=#form.reader_id#>

  <script language="javascript">
  alert (tmp);
  </script>

</cfif>

when I try this i get a javascript error " 'tmp' is undefined"

any suggestions would be very appreciated.
  
-----Original Message-----
From: Walker, Matthew [mailto:Matthew.Walker@cdc.org.nz]
Sent: Tuesday, May 09, 2000 4:53 PM
To: 'thelist@lists.evolt.org'
Subject: RE: [thelist] CF Question


> I 
> keep trying to
> use #form.name# and it is giving me tons of errors - any 
> suggestions?

That's right unless you're GETting instead of POSTing. More code would help.
What error is it giving??

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !