does arguments.object.getTable() return something that the cfqueryparam might
think is something more complicated than an actual varchar\string?
>>> [EMAIL PROTECTED] 27/09/2006 11:53 am >>>
How is this for bizarre -
If I remove the binding - i.e. change
SELECT
sequence_value
FROM
transfer_sequence
WHERE
sequence_name =
<cfqueryparam value="#arguments.object.getTable()#"
cfsqltype="cf_sql_varchar">
to
SELECT
sequence_value
FROM
transfer_sequence
WHERE
sequence_name =
'#arguments.object.getTable()#'
It all works fine.
Something is holding onto a weird binding...? any ideas?
Mark
On 9/27/06, Mark Mandel <[EMAIL PROTECTED]> wrote:
> Hey all,
>
> Oracle is giving me a weird issue, and I thought I would try here.. as
> I know we have some Oracle users.
>
> The issue is providing some small functionality that is part of Transfer.
>
> One of the things that Transfer can do for you is create unique
> numeric keys for a given table, rather than have the database do it
> for you.
>
> (This was an early design decision, and I actually don't think anyone
> actually uses it... but since it's there, I would like to keep it).
>
> Basically this is done through a table called 'transfer_sequence' that
> has 2 columns - the name of the table, and it's last recorded primary
> key value.
>
> The sequence goes like this (this is all in transfer.com.sql.IDGenerator)
>
> 1- attempt to select the value of the ID from transfer_sequence
> 2-- catch and db error, and go off and create the transfer_sequence table
> 3-- now go and attempt to select the value of the ID again
> ...
>
> This works with no issue on mySQL, MSSQL, and postgres... but some
> reason the Select call after I make the CREATE TABLE call (3) returns
> this error:
>
> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed
> SELECT sequence_value FROM transfer_sequence WHERE sequence_name = (param 1)
> (param 1) = [type='IN', class='java.lang.String', value='tbl_basic',
> sqltype='cf_sql_varchar']
>
> The wierd thing is.. I've attempted things like update calls directly
> after the CREATE call, and they run fine. It's just the select call.
>
> Anyone got any ideas? Its driving me batty, and all the other unit
> tests for oracle pass with no issues :o/
>
> TIA
>
> Mark
>
> --
> E: [EMAIL PROTECTED]
> W: www.compoundtheory.com
>
>
> --
> E: [EMAIL PROTECTED]
> W: www.compoundtheory.com
>
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
