The column you named "username" is probably a reserved word. Change the column name
and adjust your query.
Jim
http://www.creativedata.net
---------- Original Message ----------------------------------
From: "Tracy Bost" <[EMAIL PROTECTED]>
Date: Thu, 26 Oct 2000 18:00:14 -0500
>when querying a a sql 7 dataserver from the CF linux box I get this error below.
> Any ideas?
>
>MERANT][ODBC SQL Server Driver][SQL Server]Invalid column name 'Username'.
>
> Thanks,
> Tracy
>
>
>------------------------------------------------------------------------------
>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.