/*To: CF-Talk
/*Subject: turn integer list into list of characters
/*
/*I have a query that returns the EmployeeiD, on the other table i have
/*column employeeId which is varchar datatype. so my question is how can I
/*convert integer list into char list so it looks like this
/*
/*cfste list='1233
Also...you can also just put quotes around the variable in the query and
that will tell the db that it is a string...
Eric
/*-Original Message-
/*From: erik tom [mailto:[EMAIL PROTECTED]
/*Sent: Wednesday, March 26, 2008 11:24 AM
/*To: CF-Talk
/*Subject: turn integer list into list
cfset list = valuelist(myquery.columnName) /
On Wed, Mar 26, 2008 at 11:24 AM, erik tom [EMAIL PROTECTED] wrote:
I have a query that returns the EmployeeiD, on the other table i have column
employeeId which is varchar datatype. so my question is how can I convert
integer list into char list
cfset list = valuelist(myquery.columnName) /
... or use the QuotedValueList() function, if the values need to be quoted.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
erik tom wrote:
I have a query that returns the EmployeeiD, on the other table i have column
employeeId which is varchar datatype. so my question is how can I convert
integer list into char list so it looks like this
cfste list='1233','12333','333' and so on
cfqueryparam doesn't
cfqueryparam doesn't care that the input is not quoted:
Duh! Even better.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I have a query that returns the EmployeeiD, on the other table i have column
employeeId which is varchar datatype. so my question is how can I convert
integer list into char list so it looks like this
cfste list='1233','12333','333' and so on
7 matches
Mail list logo