I saw this once. It happened when the name of the first query was the same
as the variable name. Is the name of your first query "project" by any
chance? If so, you are overwriting the variable with the query structure.
- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sean Daniels
Manager, Engineering
DealStream.com
[EMAIL PROTECTED]
http://www.dealstream.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
tel: 207.439.6030
cel: 978.764.0779
> -----Original Message-----
> From: Shawn Regan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 17, 2000 6:12 PM
> To: '[EMAIL PROTECTED]'
> Subject: weird CF error or not weird but i have never seen it.
>
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01BFA8B9.E4AB2F60
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> I have two queries on the same page, both are pulling info by an client_id
> and one other field but on one of the queries i keep getting this error.
>
> Expression result cannot be converted to a string
>
> Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must
> evaluate to a value that can be converted to a string for output
> or dynamic
> text accumulation purposes. Complex objects, such as queries, arrays, and
> COM/DCOM objects, cannot be represented as strings.
>
> The error occurred while processing an element with a general
> identifier of
> (#project#), occupying document position (16:10) to (16:18).
>
> The first query has no problem with #project# but the second one does.
>
> Anyone seen this? Its a Eval version of CF server I'm going to install the
> single user server today.
>
> Shawn Regan
>
> ------_=_NextPart_001_01BFA8B9.E4AB2F60
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2650.12">
> <TITLE>weird CF error or not weird but i have never seen it.</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=3D2>I have two queries on the same page, both are pulling =
> info by an client_id and one other field but on one of the queries i =
> keep getting this error.</FONT></P>
>
> <P><FONT SIZE=3D2>Expression result cannot be converted to a =
> string</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Expressions used inside tags like CFOUTPUT, CFQUERY, =
> CFMAIL, etc. must evaluate to a value that can be converted to a string =
> for output or dynamic text accumulation purposes. Complex objects, such =
> as queries, arrays, and COM/DCOM objects, cannot be represented as =
> strings.</FONT></P>
>
> <P><FONT SIZE=3D2>The error occurred while processing an element with a =
> general identifier of (#project#), occupying document position (16:10) =
> to (16:18).</FONT></P>
>
> <P><FONT SIZE=3D2>The first query has no problem with #project# but the =
> second one does.</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Anyone seen this? Its a Eval version of CF server I'm =
> going to install the single user server today.</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Shawn Regan</FONT>
> </P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01BFA8B9.E4AB2F60--
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
