This is a multi-part message in MIME format. --Boundary_(ID_N7DDXjZSzjlaWeiYsfXRzQ) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT
Hello, I am trying to use DW MX to create a small CF application. I am working with a SQL Server database where I created a login called bmadmin to administer this particular table. When creating a recordset in DW MX for some odd reason it lists the same table twice -- dbo.tbl_songs and bmadmin.tbl_songs. In addition the fields of the table are listed twice, i.e. ID, title, lyrics, ID, title, lyrics. What is the problem and how to fix it? Thanks, Mitko Gerensky-Greene **************************************************************** "Make no search for water. But find thirst, And water from the very ground will burst." (A Persian mystic poet, quoted in Delight of Hearts, p. 77) "The world is but one country and mankind its citizens" Baha'i Faith http://www.us.bahai.org ***************************************************************** --Boundary_(ID_N7DDXjZSzjlaWeiYsfXRzQ) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2716.2200" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Hello,</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>I am trying to use DW MX to create a small CF application. I am working with a SQL Server database where I created a login called bmadmin to administer this particular table. When creating a recordset in DW MX for some odd reason it lists the same table twice -- dbo.tbl_songs and bmadmin.tbl_songs. In addition the fields of the table are listed twice, i.e. ID, title, lyrics, ID, title, lyrics.</FONT></DIV> <DIV><FONT face=Arial size=2>What is the problem and how to fix it?</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Thanks,</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Mitko Gerensky-Greene</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>****************************************************************<BR>"Make no search for water. But find thirst,<BR>And water from the very ground will burst."<BR>(A Persian mystic poet, quoted in Delight of Hearts, p. 77)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>"The world is but one country and mankind its citizens"<BR>Baha'i Faith <BR><A href="http://www.us.bahai.org">http://www.us.bahai.org</A><BR>*****************************************************************</FONT></DIV></BODY></HTML> --Boundary_(ID_N7DDXjZSzjlaWeiYsfXRzQ)-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists