[thelist] CF Question

Walker, Matthew Matthew.Walker at cdc.org.nz
Wed May 10 17:12:27 2000


> After a lot of investigation I figured out that I am getting 
> an invalid
> number error from Oracle because CF is passing all 5 
> reader_id's separated
> by commas to the action page. 

CF isn't passing the reader_id's separated by commas, your *browser* is.
That's the standard way to do it where there is more than one field with the
same name. Try this in your query:

where reader_id in (#form.reader_id#)

(I think that's the right format, I'm a big faker with SQL).

Regards,
Matthew Walker
Canterbury Development Corporation
Christchurch, New Zealand
Tel +64-3-379 5575