Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

string of ids

Status
Not open for further replies.

mayathebee

Programmer
Jun 24, 2003
16
0
0
ZA
I am passing in a string of ids to crystal reports from coldfusion e.g. (345,234,454)
The '{dbtable.fieldname} IN [{?parameterx}]' formula gives me the error "The array must be subscripted". Please help as I can find no reference on this.
 
Could there be a syntax issue - i.e. what you're passing in is not able to interpeted as an array?

If this is the case, something like this may work:

FIELD IN SWITCH({String being Passed}, ",")
 
I have added the switch..seems i have another problem. The db.field is a numberic value. The error that I now get it is 'A boolean is required here' with the passed in string part where i added switch.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top