The easiest way to see what the problem is, is to break down the complex
_expression_ into separate lines. I would recommend that anyway since the
current _expression_ isn't very readable and uses of iif and de are always
suspect.

-Matt

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On Behalf Of Ken Ferguson
> Sent: Tuesday, July 13, 2004 10:15 AM
> To: CF-Talk
> Subject: CF to BD inconsistencies
>
> I've just started moving some stuff over to a server running BlueDragon
> (free version) and I've found a couple of inconsistencies...
>
> Anyone know why the following code works fine in CFMX but not so well in
> BlueDragon. When run in BlueDragon I get an error: "Invalid index to
> query column. valcol cannot be evaluated to an integer value."
>
>
>
> <cfset selected = iif(listfind(ivalue,iquery[valcol][x]),de("selected"),
> de(""))>
>
>
>
> Here's the call and the function:
>
>
>
> <select
> #request.ff.in.select("tBillToState",qShipToFormData.tShipToState,qState
> ,"tState","tState","")#>
>
>
>
>
>
> <cffunction name="in_select" returntype="string"
>
>             output="false" hint="returns an html select list">
>
>             <cfargument name="iname" type="string" required="true">
>
>             <cfargument name="ivalue" type="string" required="true">
>
>             <cfargument name="iquery" required="true">
>
>             <cfargument name="valcol" type="string" required="true">
>
>             <cfargument name="labelcol" type="string" required="true">
>
>             <cfargument name="option1" type="string" default=",please
> select#repeatstring('&nbsp;',15)#">
>
>             <cfargument name="size" type="numeric" default="1">
>
>             <cfargument name="multiple" type="boolean" default="false">
>
>             <cfargument name="maxlength" type="numeric" default="25">
>
>
>
>
>
> This may look really familiar to you Isaac!
>
>
>
> Thanks,
>
> Ferg
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to