What's the name of the database on the sql 7 server, that the datasource
that #RRRDS# evaluates to, is pointing to?
jason
> 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.
>
------------------------------------------------------------------------------
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.
