Ok. Thanks
<CFQUERY name="CheckUsername" datasource="#RRRDS#">
SELECT U.*
FROM Users U
WHERE U.Username = '#form.Username#'
AND U.User_ID <> #SelectedUser_ID#
</CFQUERY>
----- Original Message -----
From: "Tim Storm" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Thursday, October 26, 2000 6:57 PM
Subject: Re: Error connecting to MSSql database
> how about showing your code snippet of the query?
>
>
> ----- Original Message -----
> From: "Tracy Bost" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Thursday, October 26, 2000 6:00 PM
> Subject: Error connecting to MSSql database
>
>
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_0062_01C03F76.9767B1A0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > when querying a a sql 7 dataserver from the CF linux box I get this =
> > error below.
> > Any ideas?
> > =20
> > MERANT][ODBC SQL Server Driver][SQL Server]Invalid column name =
> > 'Username'.
> >
> > Thanks,
> > Tracy
> >
> > ------=_NextPart_000_0062_01C03F76.9767B1A0
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META content=3D"text/html; charset=3Diso-8859-1" =
> > http-equiv=3DContent-Type>
> > <META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=3D#ffffff>
> > <DIV><FONT face=3DArial size=3D2>when querying a a sql 7 =
> > dataserver from the=20
> > CF linux box I get this error below.</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2> Any ideas?</FONT></DIV>
> > <DIV><FONT face=3DArial =
> > size=3D2> =20
> > </FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>MERANT][ODBC SQL Server Driver][SQL =
> > Server]Invalid=20
> > column name 'Username'.</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2> Thanks,</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2> =
> > Tracy</FONT></DIV></BODY></HTML>
> >
> > ------=_NextPart_000_0062_01C03F76.9767B1A0--
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> > To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&;
> body=lists/cf_linux or send a message to
[EMAIL PROTECTED]
> with 'unsubscribe' in the body.
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
